I have a form with two combo boxes and two command buttons. Each command button opens a seperate form, which adds data to their own tables.
on the main form, the second combo box gets its data based on the selection in the first combo box.
the problem is, i have it set up so that a user can click a text box, and add a new item to the table for the first combobox. but after they add the new item, it WILL NOT show up in the combo box unless they select something else in the box, and then go back and look again.
in my code for the command buttons i have it requery both boxes, and i have for the on_click event on the first combo box to requery.