Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old September 28th, 2006, 11:02 AM
Registered User
Join Date: Sep 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Dynamically change the data on a combo box


I'm building a form where the user will enter receipt quantities and the bin for a purchase order. I want the user to select the bin using a combo box. However the bins of the combo box depend on the warehouse of each line.

Right now I got it working by using combo.requery on GotFocus for the combo, but it's actually requerying the boxes of all lines and it produces a flickering effect on the input fields. My test POs are small but when we go live they'll be large and I'd like to avoid this flickering.

How can I requery only the current record? I've also tried to dynamically change the source data for the combo but I haven't found the right code yet.

Thank you,
Old September 28th, 2006, 11:34 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

Requery the second combo on the After Update event of the first combo.

Old October 2nd, 2006, 08:59 AM
Registered User
Join Date: Sep 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts

Thanks for the suggestion.

I tried it and the flickering remains the same, but it also let the user jumps from one to another to another combo in a different row (same column of course) and the data is not refreshed...

Similar Threads
Thread Thread Starter Forum Replies Last Post
Filtering Data from one Combo Box to another Steve1977 ASP.NET 3.5 Basics 1 September 14th, 2008 08:50 AM
Rebinding a data to combo box zaki79 .NET Framework 1.x 2 April 25th, 2008 04:43 AM
Access Data from a combo box darkhalf Access VBA 1 February 22nd, 2008 04:28 PM
change event of combo box jthadathilm16 VB Databases Basics 3 April 27th, 2006 02:05 AM
Combo Box - Data In Use MrDannyP Beginning VB 6 1 November 15th, 2003 10:37 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.