Thread: Parameter Queries
03-10-09, 06:44 #1Registered User
- Join Date
- Feb 2009
Unanswered: Parameter Queries
I understand how to make a simple parameter query but i am now at the stage where i want to limit to values that can be entered into the prompt box. This is because i only want values that are present in my Product_ID column in my Product_Table to be able to be entered in the prompt box this meaning i wont get no results on my search.
The reason for this is that the parameter query is bound to a form and if i enter an product ID that is not equal to one in my product_ID column the form displays completly blank so i need to limit the values that can be entered so that only values from my Product_ID column can be entered.
Any Ideas? Much Appreciated
03-10-09, 10:38 #2Registered User
- Join Date
- Sep 2002
- South Wales
Create a query of your product_ID field and use this as the rowsource of an unbound combo control on your form.
Then set the properties of the combo to 'LimitToList = True' so they cant free-type.
You may also want to ensure that the list is in a certain order although I suspect you know how to do this (Using the Order By Clause or adding a sort column in the query designer).
Give us a shout if you get stuck or don't understand.Windows Server 2003-8 / Terminal Services / SQL 2000 / Access 2003 / Office 2003-7 / Exchange 2003-7 / Blackberry Enterprise Server / AutoCAD / Lambert And Butler / Red Bull