Access Question on Drop Down List in Access 2007
Posted on 2011-09-21
I have a Drop Down List in my Access 2007 application that has a drop down List for Vehicle Type with this listing:
• Motor Home
• Personal Water Craft
• Truck & Trailer
• Self-propelled Campers
If the Boat is selected in the Drop Down, I want another Drop Down List to show for Boat with these fields:
Fields for Boats
• Boat Year
• Boat Make
• Boat Hull Serial
• Boat Reg Number
• Boat Decal
• Boat Length
My question, is there a way in Access 2007 to hide the Boat Field Drop Down until actually needed. The Boat Field listing would only show if the Boat is selected as a drop down choice somehow.
In VB I can do this with logic by using an IF Statement or Case Statement.
If the Boat Field is selected in the Vehicle Type Dropdown, make the Boat Field Visible, otherwise keep invisiblew inless needed.