criteria does not work

[Guest]

I am using 2 combo boxes that allow input on a form. I am trying to set up a
query that that allows me to select a name and then a [between] date. The
query runs the between dates but will not work for the name. I am using -
Like "*" & [Associate Name] & "*" - but it does not prompt when the query is
run only the Between date runs.

Table (Tblevents) colums are:
Associate Name
Date
Function
Sub Function
Oldest
Hold Over

 

[fredg]

I am using 2 combo boxes that allow input on a form. I am trying to set up a
query that that allows me to select a name and then a [between] date. The
query runs the between dates but will not work for the name. I am using -
Like "*" & [Associate Name] & "*" - but it does not prompt when the query is
run only the Between date runs.

Table (Tblevents) colums are:
Associate Name
Date
Function
Sub Function
Oldest
Hold Over

You can't use a field name as a prompt.

As criteria on the [Associate Name] field, write:
Like "*" & [Enter a Name] & "*"

Note: Date and Function are reserved words and should not be used as
field names.

For more information and other reserved words see:
http://www.allenbrowne.com/AppIssueBadWord.html