Hello all,
I have a form, which contains about 10 subforms....each subform is for different TYPES of equipment, and so each contains a field called "Manufacturer".
What I would ideally like to do is be able to double-click the dropdown box for Manufacturer, and be able to edit/delete/add the items in that list. When the form is closed, the combo box would be updated.
I have done this all over the database, but because these are all subforms, the only way I can see to do it is to individually requery each manufacturer field when the manufacturer form closes. This would be a REAL pain in the proverbial. I would like to do the same elsewhere....but hit the same problem.
I thought I could simply requery the whole form, as in, the main form that all the subforms rest in, but that doesn't work.
Any suggestions?
I have a form, which contains about 10 subforms....each subform is for different TYPES of equipment, and so each contains a field called "Manufacturer".
What I would ideally like to do is be able to double-click the dropdown box for Manufacturer, and be able to edit/delete/add the items in that list. When the form is closed, the combo box would be updated.
I have done this all over the database, but because these are all subforms, the only way I can see to do it is to individually requery each manufacturer field when the manufacturer form closes. This would be a REAL pain in the proverbial. I would like to do the same elsewhere....but hit the same problem.
I thought I could simply requery the whole form, as in, the main form that all the subforms rest in, but that doesn't work.

Any suggestions?