Hi Everyone,
I've had some success building my multi-criteria selecting interface for my Access users.
I've been repeating the same process over and over, but I've finally gotten to my criteria that are a little bit tricky.
Check out my process and my challenges.
Process
I have an "inputTable" linked to a form where the user selects limited information from the "knowledgeTable"
I then have a command button calling macros to run a premade query linking the "inputTable" with the "knowledgeTable"
This creates a one to many relationship where I can choose to only have information selected where the "inputTable" value is equal to its corresponding column in the "knowledgeTable"
Challenges:
1) Interestingly, with the command button, I can no longer enter multiple information into my inputTables and eventually I will need to be able to.
I'm a bit stuck on that.
2) Also, I need to allow the users to input a date qualification. Meaning select no data with dates older than xx/mm/yyyy
I'm not sure how to do this either.
Thanks for any help with this![]()
Let me know if it's not clear or if you have any questions.