I created 2 cascading combo boxes in my form, and they work as designed. The problem I am encountering is that the information entered into the combo boxes is not being retained in the associated table, or in the records themselves on the form.



I have 2 cascading combo boxes: Client and Product. The Client field access information in the tblClients table. The Product field accesses information from the table set up for each client, with their respective products. (I have several tables created for each client/product). This function is working fine. When selecting a particular client, the Product field only brings up those products associated with the client.

The problem I am encountering is that the data in the Client and Magazine field is not being saved in either the form, or the associated table in the database.

Can anyone enlighten me on why I am having this issue? Thanks very much for your assistance!