refresh form based on popup form(Combo box)

[Eric Blitzer]

Windows/98/2000
Access 2000
My database has become too big for bound forms. I have a
popup form with a combo box selecting my record ID. I
have a second unbound form based on a query that
references that combo box on my popup form for the
criteria. When I change the record id in my combo box I
want to requery the 2nd form and pull up the information.
It works on initial opening but I don't know the
syntax/commands to refresh the 2nd form with the changed
value in my popup form combo box.
1 - Is this the best way to go about?
2 - If so how

thanks for the help

Eric

 

[losmac]

Sub Combobox1_Change()
'change query on which is build form 1 and then
Forms("First").Requery
End Sub

For example how to dynamic change query, look here:
http://www.losmac.republika.pl/access/p05.html