Query Prompt

[Anthony Gauci]

Is it possible to put a combo box with a drop down list in the Enter Parameter Values of an update query so that the user selects from the list instead of typing the required value?

Tony

 

[mresann]

Yes. Use the same format for inserting data from a text box control.

NOTE: Depending on the column formatting, the combo box value may not necessarily be the same as the text you see in the cbo text field box.

 

[KenHigg]

Tony,

I think you'll have to create a small custom form for this and then put your combo box on it...

 

[Anthony Gauci]

I have a table with five names and I want the user to select from this table. When I put [Enter name] in the Update To field in the query I am getting a text box not a combo box.

 

[Anthony Gauci]

Hi Ken,
If I create the form how do I put it in my update query as a prompt then?

 

[mresann]

I thought you were referring to a form that you created. The query parameter request popup cannot be changed.

 

[KenHigg]

Perhaps I should back up and ask how you start the query? Do you have a button on a form that runs it or do you go into the database design view and select the query and run it?

 

[Anthony Gauci]

I have a small form with a RUN Query command button

My query has 6 prompts but I only wish to change one of them to a combo box.

 

[KenHigg]

Perfect. On this form do the combo box. For it's row source use the table with the names. Then in the query, where you have the [Enter Name], do something like:

like forms!myFormName!MyComboBoxName

Make sense?

 

[Anthony Gauci]

I am trying this out but I'm getting an invalid syntax error. DO I have to put parentheses and do I remove the [Enter name] part. Thanks

 

[KenHigg]

Yes - take out the [enter name] part...