prevent a user from changing a combo box value (1 Viewer)

[Darla123]

Hello everyone! I have a form that has 2 combo boxes on it. MainCategory and SubCategory. Ideally the user selects the main category, and then the sub category, and it all goes into a report nicely. However, I am running into an issue where at times the users are going back in and changing the main category, and the sub category stays the same, so now we have a record where we have a sub category under a main category that doesn't apply. How do I fix this so that the Main and Sub categories are tied together so we don't have a bunch of stuff in the wrong main category?

 

[bob fitz]

How about some code in the After Update event of the Main Category that clears the value in the sub category combo box.

 

[Gasman]

I would have thought that you would want cascading combo boxes so that the data remains correctly linked.?

http://www.access-programmers.co.uk/forums/showthread.php?t=219997