Cascading Combo Problem


W

whitjl143

I have tried everything I can find here in the discussion groups.
Table – Customers
Fields CustomerID
CompanyName

Table – Contacts
Fields ContactID
CustomerID
ContactName
ContactPhone
ContactFax

I have a form. On that form I have a combo box called CustomerName that is
based on the table Customers. I have a combo box called ContactName that is
based on the table Contacts. I need to have the ContactName combo box only
show the contacts for the Customer that is chosen in the CustomerName combo
box. When I do get the ContactName to show only the Customers it applies to,
I can only choose the top name. If I move to another record and go back to
the previous form, the name is missing but it is still stored in the
underlying table.
Any help is greatly appreciated! Been working on this for two months on and
off!
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top