Avatar of gtmathewDallas
gtmathewDallas
 asked on

"Enter parameter value" - MS Access

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.
Microsoft Access

Avatar of undefined
Last Comment
gtmathewDallas

8/22/2022 - Mon
Rey Obrero (Capricorn1)

better upload a copy of your db...
gtmathewDallas

ASKER
Getting the issue in from frm_edit and using the input parameter in query5 and query6
test-SB.accdb
ASKER CERTIFIED SOLUTION
PatHartman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
gtmathewDallas

ASKER
Great, Thanks PatHartman
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck