Cascading Combo Problem

[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!

 

[Golfinray]

Try Martin Greene at www.fontstuff.com and Allen Browne at
www.allenbrowne.com Both have good examples of what you are trying to do.

 

[whitjl143]

I have tried the solution from both websites and they are not working.

 

[Douglas J. Steele]

See whether what I had in my February, 2006 "Access Answers" column in
Pinnacle Publication's "Smart Access" is what you're after.

You can download the column (and sample database) for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html