Advanced Beginner
Windows 7 64bit 
Access 2016
I need to make a form that has several dropdowns to choose options, exterior color, interior color, engine size, wheel size, trim level, etc. Many options are not compatible with other options. Sometimes it is due to 3 or 4 other selections that an option might not be compatible, not just one. Do any of you have any recommendations on how to best handle preventing incompatible selections from being made?
Access Developer
Windows 10 Access 2016
Perhaps you could use Cascading Combo boxes where the available values in a combo box are dependent on the values selected in other combo boxes.
Try a search for "Cascading" or "Cascading Combo" or post back if you need more help
If this helped, please click the star at the bottom left of this posting and add to my reputation
Bob Fitzpatrick
VIP
Windows 10 Access 2016
Hi
Can you upload a zipped copy of the database so we can see the table structures?
You can PM me for help. Good Read https://docs.microsoft.com/en-gb/off...on-description
To attach file: https://www.accessforums.net/showthread.php?t=70301
Posting Permissions
Reply With Quote