Search and Display

[NewfieSarah]

I am using Microsoft Access 2000, I dont have very much knowledge with the program. I need to Seach By a Combo box, Contact name... Through the database and then Display only the information for that customer in the list box. I have been researching this for weeks now and I need Help. If anyone could help it would be great. Thanks.

 

[ColinEssex]

I have been researching this for weeks now and I need Help. If anyone could help it would be great. Thanks.

What have you done so far?

Customer Table (with autoNumber as ID)?
Orders table (with AutoNumber as ID and FK as CustomerID)?

Col

 

[NewfieSarah]

Situation

here it is, I have a table for contact information... called visitors. In my Visitors databast. I want to have the database used to search by Name, location, and more.. ???? no key field.

 

[Ukraine82]

Seems like you looking for cascading combo box search.

Take a look at the attachment file...

hth,
Michael

 

[NewfieSarah]

Thanks

Thanks for the file but it is not really what I am looking for. For what I am doing I need user input.. Thanks anyways

 

[WayneRyan]

Sarah,

What Michael showed you was user input! He's using a set of
cascading combo-boxes to let the user specify what records to
show.

How about posting a sample of your database here and someone
will give you some search ideas.

Wayne