Using Criteria's in Query

[gilescis]

Is there a way to have a Criteria set to promt a user to select a item from a dropdown list.

So when the prompt is made to ask for the Item Name it will have a dropdown list that the user can choose from

 

[pbaldy]

Using the [Enter criteria] method, no. You'll need to create a form with a combo and have the query look there for the criteria.

 

[gilescis]

Thats what I thought , I could not get it to work so I wanted to make sure it is impossible to do

 

[gilescis]

Paul,
I have another question thats been killing me. I have a smal DB. How can I send the app to you to look at to see what I am doing wrong in getting a combo box to lookup a name from a table and populate the address then have that data saved to another table that is all part of the order.

Dean

 

[pbaldy]

You can post the db here (compacted and zipped). That way you aren't limited to my input.