Hi guys,
Sorry if there's some introduction page I'm meant to fill out before posting but I'm in some strife with this problem
So basically I have to create a Decision support system (DSS) using access as a university project. I've decided to create this DSS based on a car rental company fleet with the following attributes - manufacturer, model, seating capacity, baggage capacity and vehicle type. What I tried originally was to create multiple queries against this table to filter out say all hatchbacks, or all vehicles with a baggage capacity of more than 3 etc. However what I ended up doing was creating individual tables listing all possibilities (I only have 10 vehicles so it wasn't too many tables to write out). So that's the background.
The problem lies in macro's and combo boxes. So basically the DSS has to involve some sort of user input hence why I used combo boxes to allow a client select and input what they are after i.e. the database will ask "how many passengers do you have" and the combo box will have answers from 1-5 and the idea is to then remember this answer and grab the matching table to present to the client. This is all well and good however it gets complicated as you make it a step by step procedure. My system will firstly ask, how may passengers, then how much baggage and then the preferred vehicle type. On the last form, when the user hits continue, I've macrod that button to have an "If" statement which basically states if the user selects x amount of passengers and baggage and vehicle abc then grab xyz table.. Following still? I'll attach screen shots to explain better.
Now to get to the grunt of the problem. Basically, while the first query will fetch the appropriate table no problems, each subsequent line of code I write after in the macro section essentially doesn't work. When the continue button is pressed on the last form, access will always run the first line of macro but not the subsequent line even though the parameters are not met by the first macro but they are met by the second.
Here's an example of my combo box. This is the last form I refer to, after hitting continue on this form, the idea is that the database will remember the two previous answers and return the correct table.
Here's the macro code that relates to the button "continue" on the form above. My plan was to write a new line of code every time until all possibilities had been achieved. However the issue is that despite there being two codes there (the only difference is the 1 and 2 on the end of the code) only the first one gets applied. Am I incorrectly coding this?..
Lastly here's the table that I want to be returned to the user based on the answers. This table actually relates directly to the first macro line in the above image.
Guys, I really appreciate it if you've made it this far. I know it's a long winded question but I really have no alternatives, I've been at this assignment since I've got it and the curriculum of my degree is retarded and despite the fact I've never done programming or coding during the last 3 years, the uni's decided to give this as an assignment smh.
Anyway cheers guys, please don't hesitate to ask more questions if it doesn't make sense!