I have a form that has a combo box, a list box, and a few text boxes.
Currently, when the user selects the combo box, the list box populates options based on the combo box selection. The text boxes on my form do not update until I select the record on my list box.
How do I make it so my list box automatically selects the first record after I change the combo box selection? This would make my text boxes change when I changed my combo box, instead of them only changing when I select something on the list box.
Thank you for your quick response, but I have tried that previously to no avail. I retried it after reading your suggestion and I copied and pasted the afterupdate event code from the listbox to the combobox and it still does not do what I am trying to get it to do.
Not sure. I copied all the code from the listbox and put it after the existing code in the combo. Now when I make a selection in the combo, the various address and date textboxes change values as appropriate to the selected record in the listbox (I assume; I haven't actually looked in the table). Have I misunderstood the goal?
That is the desired goal, however, when I am working with a larger population of data, (thousands of companies), it is not working.
When I type in the company in the combobox and hit enter, it does not return to me the entered company's info, but it gives me the next company's info (the 2nd, then the 3rd, then the 4th, etc, as I try again).