Based on a previous post, I used [Forms]![Search Form]![MLO #] in my query to
refer to my form and put a command button to run the query. The MLO # is a
catalog number in the form of ####-####. I am able to run the query for
exact matches to the entire field but it doesn't work for ranges or matches
to part of the field. Is there a way to use wild cards on the form? I've
tried typing an expression on the form as I would on the query, such as
>####-####. I also have a column for desciption refered to as
[Forms]![Search Form]![Description] in my search. For this column we usually
search with * because the search criteria is only part of the field. In the
form I tried using *criteria* and it didn't return anything. Also in the
query I tried putting *[Forms]![Search Form]![Description]* and access
changes it to Like "*[Forms]![Search Form]![Description]*". Thanks for the
help.
ByMarcie
Douglas J. Steele - 17 Mar 2008 18:44 GMT
Try changing that to
Like "*" & [Forms]![Search Form]![Description] & "*"

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
> Based on a previous post, I used [Forms]![Search Form]![MLO #] in my query
> to
[quoted text clipped - 16 lines]
> help.
> ByMarcie
bymarce - 17 Mar 2008 21:05 GMT
Thankyou very much. It worked.
ByMarce
> Try changing that to
>
[quoted text clipped - 20 lines]
> > help.
> > ByMarcie