2 field find / search criteria on a form

[Fred]

I posted this already and it disappeared.

Experiences on Access (but not on this!), very newbie on code

Looking to add something to a form to allow user to search for a record
based on two criteria. For example:

Enter the first few letters of the company name (can require user to enter *
/ wildcard if necessary
Enter their city l

An then it would go either to the firt record that meets those criteria, or
else filter based on those criteria (whichever is simplest)

Any help would be appreciated!

 

[Allen Browne]

Fred, download the example database here:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

The example shows how to build a filter string from the boxes where the user
entered something. It shows how to work with different data types (text,
numbers, dates), partial matches, and even a date range. It will take you
half an hour to work through the example, but will be worth your while.

 

[Fred]

Hello Allen,

Thanks!

I downloaded it. For me it will more likely take 30 days than thirty
minutes to find and figure out the code (I think I found the main block, and
it is nicely annotated) but even then, as you noted, it will be well worth
my while.

Sincerely,

Fred