Click on a field in a navigation form to bring up a second form

[xmattxman]

I have a form set up called RMA_DATASHEET. I embedded a macro on click so that when someone clicks on the OH_NUMBER field it will bring up a second form that has more detailed information. That works perfectly until I drop the RMA_DATASHEET into a navigation form. After doing that when I click on OH_NUMBER I get this prompt. Enter Parameter Value Forms!RMA_DATASHEET!OH_NUMBER.



I am sure it is something simple just not sure what. Any ideas on the issue? I attached 2 images to help you understand a little better.

[pbaldy]

The form reference changes (forget how exactly on navigation forms as I don't use them). If you want to use VBA, the "Me" reference would still work:

http://www.baldyweb.com/wherecondition.htm

[xmattxman]

So I did VBA instead DoCmd.OpenForm "frmOPEN_RMA_AND_RMA_CONC", , , "OH_NUMBER=" & Me.OH_NUMBERI but I get Run Time error 3464 and idea why?

[xmattxman]

I got it working with this DoCmd.OpenForm "frmOPEN_RMA_AND_RMA_CONC", , , "OH_NUMBER = '" & Me.OH_NUMBER & "'" Thanks for the help!!

[pbaldy]

Happy to help! You can add an argument to open in dialog mode if you want, as was done by your macro.