Combo Box requery

[JK]

I have the following code to requery a combobox on a seperate form.
'~~~~~~~~~
Private Sub Form_Unload(Cancel As Integer)
if currentproject.Allforms("formname").IsLoaded = true then
forms!formname!controlname.Requery
DoEvents
End If
'~~~~~~~~~
I am using this code to automatically change the cityID combobox, I have
many forms that link to this form so how can I include all the possible forms
into thi one Unload Event Procedure?

 

[Jeanette Cunningham]

Hi JK,
have a look at this link. Allen Browne describes how he uses a function
called NotifyCombos to do this.
http://groups.google.com/group/micr...8431ce3?lnk=gst&q=forms+flow#540b502f08431ce3


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia