dgambale@gmail.com
Registered User.
- Local time
- Today, 05:45
- Joined
- Jul 31, 2013
- Messages
- 19
Hello,
For the life of me I cant seem to figure out the correct syntax and was hoping someone could provide some help and the specific syntax needed.
I had a form "Quotes" that worked perfectly and upon clicking a button opens a report using the following code and set the Quote_ID to the Quote_ID of that specific record:
DoCmd.OpenReport "rptquoteExtreme", acViewPreview, , "Quote_ID=" & Me!Quote_ID
I have recently added a navigation bar called "Navigation" and now get the message "Enter Parameter Value Forms!Quotes!Quote_ID" when the button is pressed.
I understand my form Quotes is now a subform but cant seem to get right syntax to identify the value of Quote_ID within the form Quotes so the navigation bar works correctly.
If you could provide the specific syntax that would be great.
Thanks
For the life of me I cant seem to figure out the correct syntax and was hoping someone could provide some help and the specific syntax needed.
I had a form "Quotes" that worked perfectly and upon clicking a button opens a report using the following code and set the Quote_ID to the Quote_ID of that specific record:
DoCmd.OpenReport "rptquoteExtreme", acViewPreview, , "Quote_ID=" & Me!Quote_ID
I have recently added a navigation bar called "Navigation" and now get the message "Enter Parameter Value Forms!Quotes!Quote_ID" when the button is pressed.
I understand my form Quotes is now a subform but cant seem to get right syntax to identify the value of Quote_ID within the form Quotes so the navigation bar works correctly.
If you could provide the specific syntax that would be great.
Thanks