Snowflake68
Registered User.
- Local time
- Today, 11:30
- Joined
- May 28, 2014
- Messages
- 464
I have several 'Cascading' combo boxes on a form. So basically when you select an option from the first one, the next one displays only those values that that are valid to the first selection.
I use queries to reference the combo boxes on the form to control the lists and all this works perfectly.
However if the user then goes back and changes the the value in the first combo box I want to check that the value in the second one exists in the list and then if it doesnt then colour the background to red.
For example; combo box 'County' select value 'Hampshire' will display only those towns in Hampshire in the 'Town' combo box. Select 'Portsmouth' as the town but then go back and change the county to 'Dorset' Portsmouth is not a town in Dorset so I want to inform the use to change the town to one that is now in the list for Hampshire.
Is this possible?
I am using Access 2016
I use queries to reference the combo boxes on the form to control the lists and all this works perfectly.
However if the user then goes back and changes the the value in the first combo box I want to check that the value in the second one exists in the list and then if it doesnt then colour the background to red.
For example; combo box 'County' select value 'Hampshire' will display only those towns in Hampshire in the 'Town' combo box. Select 'Portsmouth' as the town but then go back and change the county to 'Dorset' Portsmouth is not a town in Dorset so I want to inform the use to change the town to one that is now in the list for Hampshire.
Is this possible?
I am using Access 2016