Search query or lookup that fills forms

[olgimer]

I would like to know the best way for creating a query, search, or lookup
that will:

1. lookup by customer (name or addy or phone) if I have a match it stuffs
the existing customer form with that users info for account update or editing

2. If no existing record match found then gives me blank form for data entry.

I just need to know what direction to go for help builti n help files,
tutorials...???

 

[Ofer Cohen]

Check this link, it can give you a starting point

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