This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Help..how to create a dropdown box for users to make a customized query in Access?The preset function is a pop-up message with a text box asking for input value for making query, but i want a dropdown box instead of a text box so the users can select the value from the list..
I can create a window with a drop down box but how to send the value the user typed in to make the query??
-ely(Ely);
2001-2-23
{302}
(#28098@0)
-
In the tool bar, click "FORMAT"->"Change to COMBO BOX". Open the property window,click "DATA" tag, "ROW SOURCE TYPE" set to "Value List", In "Row SOURCE" write somthething like "1";"2";"3"
-guest:jian;
2001-2-23
(#28136@0)
-
My problem is the prompt asking for query criteria is the preset function of Access, I didn't find out a way to modify the layout.if i create a form as a prompt by my self with a combo, I don't know how to send the value picked up by users from the list to run a customized query. Because the query only accept a specific value as criteria if you don't want use preset prompt to input different values. My God, don't tell me i have to create query for each value.
-ely(Ely);
2001-2-23
{336}
(#28153@0)
-
No, you don’t have to.
-guest:Jian;
2001-2-23
{630}
(#28181@0)
-
It does work!!!!!Thank you very much!
-ely(Ely);
2001-2-23
(#28190@0)