2 field find / search criteria on a form

  • Thread starter Thread starter Fred
  • Start date Start date
F

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!
 
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.
 
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
 
Back
Top