Search Form, Lookup Form query?

[olgimer]

I have an Access 2003 application (Customer History). I am trying to create a
simple search fields that will give me 3 choices and a search button for
finding an existing record. I need to search by name addy and phone.

I need to be able to search by "Customer Name or Customer Address or
Customer Phone" any matching record is then diplayed in my existing "Customer
History" form for editing or updating the existing record.

If no match is found I need to go to the next blank record in the "Customer
History" form and add a new record.

Is this a basic query ?, if so what would be some good resources for
understanding this process. Is this a lookup? or a query? or both?

I suppose I could anchor these search fields on the right hand side of my
"Customer History" form and have 3 new fields and a search button? I already
have some navigation buttons over there and room for more things in my right
hand side column.

All I know how to compare this to is an ASP search and results page....I
guess this is similar.

Thanks for any help steering me in the right direction.

 

[Ofer Cohen]

Check this link, it can give you a startin point

http://www.databasedev.co.uk/text_search.html

 

[olgimer]

Thanks ....that is very close to what I'm looking for!
Phil