I have two forms, the first form has a drop down list and updates customer names on the form when a different customer is selected. I have a button that switchs to the second form, this form has contact information. On the second form I also have a button that switches back to the first form. When I go back to the first form and select a different client from the drop down list it does not update the form. Do I need to close the first form when going to the second and reopen from the second form?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Forms - Toggle between Forms
- Thread starter Adams
- Start date
ZmrAbdulla
Technical User
You can open the second form with an "acDialog" argument So the second argument to requery the combo will fire after closing the second form.
________________________________________________________________________
Zameer Abdulla
Visit Me
A sweater is usually put on a child when the parent feels chilly.
Code:
DoCmd.OpenForm "SecondForm", , , , , [b]acDialog
Me.MyCombo.Requery[/b]________________________________________________________________________
Zameer Abdulla
Visit Me
A sweater is usually put on a child when the parent feels chilly.
- Status
