Link to home
Start Free TrialLog in
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.
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

better upload a copy of your db...
Avatar of gtmathewDallas
gtmathewDallas

ASKER

Getting the issue in from frm_edit and using the input parameter in query5 and query6
test-SB.accdb
ASKER CERTIFIED SOLUTION
Avatar of PatHartman
PatHartman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great, Thanks PatHartman