This code:
Case Is >= 1
DoCmd.OpenForm stForm, , , [Manifest_ID] = " & Me![Manifest_ID]"
...should not compile. It should probably be:
Case Is >= 1
DoCmd.OpenForm stForm, , , "[Manifest_ID] = " & Me![Manifest_ID]
If statements directing to different forms and populating field
Administrator
Windows 7 
Access 2007
This code:
Case Is >= 1
DoCmd.OpenForm stForm, , , [Manifest_ID] = " & Me![Manifest_ID]"
...should not compile. It should probably be:
Case Is >= 1
DoCmd.OpenForm stForm, , , "[Manifest_ID] = " & Me![Manifest_ID]
Novice
Windows XP Access 2007
Works like a charm now. Thank you for all your help.
Administrator
Windows 7 Access 2007
Glad we could help.
Populating a "Text" field in a Report
Posting Permissions
Reply With Quote