Auto lookup query for data entry. (Newbie) 1

[Plumes]

Hi

I have a query I'm using for data entry to a table[tab_Activity] which has a field called Client_Contact. Client_Contact is a list from [tab_Client_Contacts]. When a client contact is selected data fills into some of the other fields, one of which is Client.

This works great but what I'd like to do is allow the user to first select from the Client field and then from a now short listed Client_Contact field, which will populate the remaining fields. I think the reason I'm struggling is because all the fields that are automatically populated are from tables are on the one side of the relationship to Client_Contacts, including Client as there are multiple contacts per client.

I hope this is clear.

I'd really appreciate any help with this.

Matt

 

[dhookom]

If I understand correctly, you want one combo box to filter the records in another combo box. If so, check out Roger Carlsons sample database on Cascading Combo boxes at

http://www.rogersaccesslibrary.com/TableOfContents2k.asp#C.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[Plumes]

Thanks Duane

I'm amazed you understood what I meant, it's hard to explain it when I'm so new to it. The link was just what I needed.

Thanks again

Matt