Button to search F_Name+L_Name

[Richard_Denver]

I'm a newbee & I'm trying to put a Search Button on a form which will find a record by First & Last Name

I'm using Access 2007

Can't be too hard, right?

thanks

 

[John Big Booty]

Perhaps the DB posted and discussed in this thread will help you.

 

[georgedwilkinson]

Or, you could just use Access' built in filter function on your form. Right click on the field and type in your filter criteria.

If you're serious about rolling your own, take a look at this: http://www.allenbrowne.com/ser-62.html

Though I'd say that's not for "newbees".

 

[Richard_Denver]

Thank you. I'll take a look.

 

[georgedwilkinson]

Oooo...looks like I was writing my post when JBB posted his. I wasn't saying not to take his advice, just recommending something other than what the OP was suggesting.