Search based on full or partial input

[Julie]

I posted this under new users but didn't get back the result I was looking
for so I am trying a new section...sorry. I need to know how to create a
search section that allows the user to put in an entire account number or
partial number and have it return the results by pulling up the record that
has this information. The other search I need to know how to create on my
form is a possible name, address, or what ever the user may think of that
will bring up the record. When I say whatever they think of they are aware
of the fields that is in the database (address, name, telephone number, type
of account etc) I am not good a VB so I need this information as user
friendly as possible. Thanks again and sorry for the double post but I am
kind of in a crunch for time.

 

[Tom van Stiphout]

On Wed, 17 Dec 2008 22:20:00 -0800, Julie

That's already built-in: set focus to the field you want to search,
and hit Ctrl+F

-Tom.
Microsoft Access MVP