I have an access database, with multiple tables, each table has a relationship linking everything together. I have a built an access query to pull all the fields together, that I need to be displayed on a form, I need to filter this data by what the user selects on a FORM, and modify the query to filter by 3 fields that the user would select. Similar to what this is doing: [url removed, login to view]
Except with fields being pulled in from multiple tables.
So what needs to be done is:
1. A form created with the 3 combo box’s for the fields I want them to be able to “filter” the data by.
2. Once they have selected there three selections, I need it to query all the tables and display the fields in some sort of data sheet view. (The access query I have built is just so you can reference what all fields need to be pulled in)
3. This needs to be done in ACCESS VB, built into the form, with a sql query.