I have an MS Access 2010 database that has several different versions of a report for Model details of cars and trucks. The reports are similar in some ways. (Both have stats regarding an engine and the capacity of a gas tank, for example.) But the reports are different in other ways. (The car would not have the length of a pick-up bed listed, for example.)
I have a Form where the user inputs the Model Number, and all my queries are based on that Model Number to populate the reports.
I would like for the database to...when a user puts in Model Number and clicks "Run Report"...run a Report and print it, but I want it to base the selection of which Report to run on two things:
1. Is the Model a Car or a Truck.
2. Is the Model 4-wheel-drive or 2-wheel-drive.
Those are both fields in my database, and I have 4 different forms corresponding to the 4 possible combinations. (2WD Car, 4WD Car, 2WD Truck, 4WD Truck). Those fields are associated with each Model Number, so once a user selects the Model Number, then Access should be able to say, "Oh, that is a 2WD Car, so print only the report for 2-Wheel-Drive Cars".
Is this possible? I have some coding skill, but am not an expert by any means.
Thanks for any help!