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

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.

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.

OK. That gives me some ideas of how to proceed.

Thanks!