Hi All
New to the forum with no VBA experience. Looking for some VBA help to have a 2nd listbox update based on selections in the first list box
Background - I am trying to create a "helper query builder" page for managers in our area with no Access experience but would like to create custom queries on the fly. The idea is that the user can first select the name of whatever table they would like to see data from and then once a table has been selected they can then select all of the available column headers from that table. Once the column headers have been selected they can query results based on the 2nd listbox selections.
First uploaded image shows the two list boxes
Second image shows the field, table and sort for the first listbox - currently showing the results I would expect to see - which is all tables
Third image shows the row source data for the 2nd listbox - however in regular form view the 2nd listbox is blank - hoping to get help populating that 2nd list box
Happy to answer any questions in order to make the process easier. Thank you for your time
New to the forum with no VBA experience. Looking for some VBA help to have a 2nd listbox update based on selections in the first list box
Background - I am trying to create a "helper query builder" page for managers in our area with no Access experience but would like to create custom queries on the fly. The idea is that the user can first select the name of whatever table they would like to see data from and then once a table has been selected they can then select all of the available column headers from that table. Once the column headers have been selected they can query results based on the 2nd listbox selections.
First uploaded image shows the two list boxes
Second image shows the field, table and sort for the first listbox - currently showing the results I would expect to see - which is all tables
Third image shows the row source data for the 2nd listbox - however in regular form view the 2nd listbox is blank - hoping to get help populating that 2nd list box
Happy to answer any questions in order to make the process easier. Thank you for your time