Hi all,

Using Access 2007.

I would like to setup a query to prompt user to to input two values (usually a copy paste from another document)
I need to test 2 different fields, 1 live, 1 archive for a customer number

I tried setting up in the query design grid
I entered this on the criteria line for Field 1 Like "*" & [Text ?] & "*"
And same on the OR line for Field 2

But I only receive one prompt?
What can I do so I am always prompted to enter a value in bother fields

thx
w

for the first field, you already used

Field 1 Like "*" & [Text ?] & "*"

so use another variable for field 2

Field 2 Like "*" & [Text2 ?] & "*"

I would suggest you use a form that contains two text boxes. The user will then fill in the values he wants to use for each text box, you will of course explain to him/her which value is which on the form. You could use combo boxes, list boxes, date/time pickers, etc., whatever controls seem appropriate for the values.

Then modify the query to use the values in the form controls as the criteria values.

In the appropriate Criteria: cells, place a reference to the form control, like this: [Forms]![NameOfForm]![NameOfControl]

Place a button on the form to open the query.

By using a form you can present the user with a list of correct values to pick from.