I have a form that opens as a pop-up modal when a credit card is used. If it is the first time for a given record that the card is used, it will open to a new record. How do I get the ID number from the main form stored in the appropriate field of the pop-up form? (Yes, I should know this, but somehow my mind stopped working for the holiday weekend!)
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!
storing filter value in pop-up modal form
- Thread starter LISABBB
- Start date
A couple of ways come to mind...
In the Open event of the popup form, just pull the value directly from the first form, sorta like this:
Or you could pass the value in the OpenArgs argument of the DoCmd.OpenForm command, then in the popup's Open event, write the form's OpenArgs property to the field you want.
HTH,
Ken S.
In the Open event of the popup form, just pull the value directly from the first form, sorta like this:
Code:
Me!MyIDField = Forms!TheOtherForm!MyIDFieldHTH,
Ken S.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
