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.