I have ComboList1 on Subform1 that is located in both Parent1 and Parent2 forms. The record information in ComboList1 can be edited by clicking a button on Subform1 that opens EditForm1. After changes are made, the record is saved and focus returns back to the ComboList1 on Subform1
I have alot of these "editable" comboboxes set up throught the database and I'd like an easy way to requery the combo lists on the subform after changes are made
I tried using the GotFocus of ComboList1 although I can't directly reference the ComboList1 because it may be opened through a different Parent form: Forms![??ParentForm??]!Subform1.ComboList1.Requery.
I'd like to have the code figure out what parent Subform1 is opened in and, even better, what subform the ComboList is in.
Thanks,
Brian
I have alot of these "editable" comboboxes set up throught the database and I'd like an easy way to requery the combo lists on the subform after changes are made
I tried using the GotFocus of ComboList1 although I can't directly reference the ComboList1 because it may be opened through a different Parent form: Forms![??ParentForm??]!Subform1.ComboList1.Requery.
I'd like to have the code figure out what parent Subform1 is opened in and, even better, what subform the ComboList is in.
Thanks,
Brian