Problems with a query parameter

[Bullman2000_uk]

I am writing a query that will allow a user to search for a supplier number using part of a supplier name. I cannot work out how to bring up a promt box where it is set to "like" or "contains"

I would have thought that in the criteria I would enter:

is like [enter supplier name]
or
like [enter supplier name]
or
contains [enter supplier name]


However these are not working, can you please advise how I would set this up.

This is also going to be set in a form when the user enters the name into a field and clicks on a search button to search the table of data if it is easier to do it that way round


Thanks

 

[namliam]

In a like statement you need to add wildcards for it to work. Add * to your search to search everything "containing" something

like "*" & [enter supplier name] & "*"

 

[Bullman2000_uk]

Thanks for that,

My next question is the code I need to writed for a command button.

The field you enter the part of a supplier name is is Text2 and the query criteria is set as like "*"&[Supplier]&"*" how do I get the code to feed the contents of Text 2 into the [Supplier] Criteria?


Thanks

 

[namliam]

Have you tried doing a search??? "Search form" will return some intresting results for you among which this:
http://www.access-programmers.co.uk/forums/showthread.php?t=99353&highlight=Search+form
and
http://www.access-programmers.co.uk/forums/showthread.php?t=121973&highlight=Search+form

See how far you get and ask any remaining questions here.