Navigation Bar / Subform Problem (1 Viewer)

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
 

Users who are viewing this thread

Top Bottom