I have a subform that allows a user to enter product orders. I also
have a combo box from which the user can select from a list of vendors
(from a table) and display the vendor's address in a textbox below the
combo box.
if a particular vendor is not on the list, the user may enter a new
vendor by clicking a button and filling out a popup form. upon
closing the add vendor form, focus returns to the order form where the
combo box list is updated and selected to show the new vendor and
their address below.
the problem is when the combo box control on the order form is
requeried to add the new vendor, the entire form is refreshed and i
lose my order form. the entries still exist because they link to the
order form number, but they no longer display on the subform.
currently, after adding the new vendor to its respective table, i
change the RowSourceType of the combobox to "Value List", and then
change it back to "Table/Query" and this seems to repopulate the
combobox with the new vendor without refreshing the vendor form. This
might be more of a "bug" aka "feature" than a solution, so does anyone
else have other possible solutions? I was also considering manually
populating the combobox with a function, and then manually adding an
item to the combobox as needed. would that be slower or faster?
comments, ideas?
