Hi Everyone,
So my first experience in an Access Forum was amazing!
I'm still a VBA beginning, but I'm developing a few muscles lol if you know what I mean.
So here's my next task.
Objective:
-Accessing the information relevant to what they're searching for.
-Automating the select query with varying criteria process
I have a huge query linking various tables together. It's purpose is to segment a market data table.
The problem I have is a I have non-experienced Access users who will need to use the following function:
I want them to input the criteria they're looking for into a form with the 14 variables (that's the easy part)
They would then click a button.
The button would update the select query with the various criteria the users will be desiring.
I'm not really quite sure how to do this.
-Have a table, update said table with criteria, link it to select query? - What would connect the 2, do I need to connect the 2?
Please help![]()