"Enter parameter value" - MS Access

gtmathewDallas
gtmathewDallas used Ask the Experts™
on
Hi Experts I getting "Enter parameter value" message  when I am opening a form.
In a query(to load one listbox) I am using the same parameter input value "Forms!Frm_Room_Edit.Combo_Room.Value". When I removed this combo value from the query to test the form, it doesnt showing the pop up "Enter parameter value".

The problem is I have to use this  combo in put value in query and same time I need to avoid the unnecessary input message.

This form 'A' is integrated in another main form 'B' as a subform - then I getting the error, but when I am running this form A independently, it doesn't showing any issues.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
better upload a copy of your db...

Author

Commented:
Getting the issue in from frm_edit and using the input parameter in query5 and query6
test-SB.accdb
Distinguished Expert 2017
Commented:
When you get prompted to enter a value, it is because Access cannot reconcile the reference.  That usually means a typo or other error.  In this case the problem sounds like you are trying to reference a subform without qualifying it by the main form.

Forms!  main form name   !  subform control name   .Form!  control name

Author

Commented:
Great, Thanks PatHartman

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial