Thread: VBA Code on an On Click Event Procedure

I have created 2 cascading combo boxes on a form, Client and Magazine. When the user selects the Client, the drop down for the Magazine automatically populates with the magazines specific to the client. This is working perfectly. However, if the user goes back and changes the Client, but not the Magazine, the record will save with the incorrect combination.

I also have a Submit button, that I coded to save the record and open a new one. I want to add code that will return an error message to the user, if the magazine is not one that the client supports. I have 1 table (tblclients) that lists all of the clients, but I have multiple tables broken down for the magazines for each client.

How do I write code that will verify that the magazine is one of the clients? I have already set the Limit to List field to Yes, but that will not work when the client is changed, and the magazine is not.

Any and all assistance would be greatly appreciated!

Hi CushingMT,
I think you need to requery to so if/when its changed the second list gets updated....I think this is what you are looking for.

here is an example:

Example

Not sure about the error handling.

follow sbenj69s advice.. ...

Yes, this worked perfectly. Thank you so much for your assistance.