query

[nandkumar]

I have made a small program in Access for the mailing
list.

I want to make a query, wherein if I put
(a) region - address in that region is shown
(b) name of company - persons in that company is shown

In case I am not sure of the name of the person or
company - I put only part of the name and the program
shows me all the fields with matching names & I can select
from that.

Please help