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

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

mmcdonal

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...