Options:
1. form/subform arrangement
2. OpenArgs argument of OpenForm
3. global variable
4. TempVars
5. code behind second form references first form to pull data
6. code behind first form sets value of control on second form
7. dynamic parameterized query as second form RecordSource
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Ooops, yeah, that should have been option 1
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Yeap, it worked. Thanks.
Happy to help!