DoCmd OpenForm - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

DoCmd OpenForm

Walter Hamilton

4 years ago

I'm having an use running: DoCmd.OpenForm. my syntax is as follows:

DoCmd.OpenForm [frm_NDA], , , "[NDA_ID]=" & [NDA_ID]

I keep getting the following VIsual Basic Error:

Run-time error '2465':

OWT Management 4 v.2 can't find the field '1|' referred to in your expression.

Both forms have NDA_ID as a hidden field in the form. I can't seem to get the syntax correct. I've looked back at other forms where I use this command and I think I'm constructing it the same way.

	Kevin Robertson @Reply 4 years ago
Your form name needs to be in double quotes. `DoCmd.OpenForm "[frm_NDA]", , , "[NDA_ID]=" & [NDA_ID]`

	Adam Schwanz @Reply 4 years ago
What about DoCmd.OpenForm "frm_NDA"

	Adam Schwanz @Reply 4 years ago
Sat on this question too long before pushing submit, what Kevin said haha

	Kevin Robertson @Reply 4 years ago
LOL Adam

	Walter Hamilton OP @Reply 4 years ago
I updated it to reflect the following: DoCmd.OpenForm "[frm_NDA]", , , "[NDA_ID]=" & [NDA_ID] I'm now getting this error message Run-time error '2102' The form name '[frm_NDA]' is misspelled or refers to a form that doesn't exist. I'll attahed a screenshot showing that frm_NDA exists.

	Walter Hamilton OP @Reply 4 years ago

	Walter Hamilton OP @Reply 4 years ago
Kevin - I also tried to opening frm_NDA and I get the Run-time error 2102 message with it as well. It's weird because the form exists.

	Walter Hamilton OP @Reply 4 years ago
OK. I got it to work. Adam was the key. The following command works: DoCmd.OpenForm "frm_NDA", , , "NDA_ID=" & NDA_ID Thanks for your assistance.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View