Is there a way to create a parameter query where the user can select from a list, instead of typing in a value, when the "Enter Parameter Value" dialog box appears?
Thanx in advance.
Is there a way to create a parameter query where the user can select from a list, instead of typing in a value, when the "Enter Parameter Value" dialog box appears?
Thanx in advance.
the criteria for a prompt is
Code:
SELECT Table1.Field1
FROM Table1
WHERE Table1.Field1=[Prompt description message];
Hello llkhoutx,
Thank you for responding to my question. Unfortunately, I did not understand your answer where you say "PHP code:" and then list SQL statements. Let me clarify: I am not writing in PHP, but rather creating a simple Access databse, where I am trying to create a parameter query such that the user can select the parameter value from a list, rather than having to type it in.
Currently, the SQL behind my query looks like this:
SELECT ...
FROM ... INNER JOIN ...
WHERE (((tblServices.Service)=[Please enter Service]));
When this query is run, a dialog box appears requesting the user to type in a value for the field called "Service". I would like that dialog box to contain a list box or combo box, so that the user can select from a list of currently available services.
I can accomplish this by writing a VBA module to create my own dialog box or form containing a list box control, but I was wondering if there were a simpler way to do it using a standard Access parameter query.
Thank you again for responding to my question.
is added automatically which inserting something on this form in a window pane. I have no control over that being added to my post.Code:
"PHP code:"
A list box row cannot be referenced directly. One would have to store the list box selection in an unbound textbox and then that textbox can be referenced.
A combox box name can be referenced.
Problems arise with multi-column combo boxes and multi-column list boxes. I'll not address these issues, as they are apparently at issue.
Code:
SELECT ...
FROM ... INNER JOIN ...
WHERE tblServices.Service)=Forms!FormName!ControlName;
OK. That gives me some ideas of how to proceed.
Thanks!