|
Subject:
|
Dynamically change the data on a combo box
|
|
Posted By:
|
soc22
|
Post Date:
|
9/28/2006 11:02:30 AM
|
Hi,
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,
Sergio
|
|
Reply By:
|
mmcdonal
|
Reply Date:
|
9/28/2006 11:34:57 AM
|
Requery the second combo on the After Update event of the first combo.
mmcdonal
|
|
Reply By:
|
soc22
|
Reply Date:
|
10/2/2006 8:59:19 AM
|
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...
|
