troubleshooting Question
Access 2013 web app use combo box value in query grid to filter records
asked on
How do I solve the problem of using the value in a combo box as a filter within a query so that only matching records are used in a subsequent form view.
Example:
Combo box on a screen called [SelectNumber], user selects number 3
After update of combo box will open a form linked to query1, where one of the table fields [MyNumber] is numeric.
This view should only contain those that match number 3. Cannot reference [SelectNumber]
This is a simple explanation for what will be more complex implementation. I have looked at setvariable but still cannot reference the variable in a query grid. Massive data macro examples on line confuse the h**l out of me.
There must be a simple solution for something that would be the bedrock of any decent system?
Have used Access desktop for many years.
Example:
Combo box on a screen called [SelectNumber], user selects number 3
After update of combo box will open a form linked to query1, where one of the table fields [MyNumber] is numeric.
This view should only contain those that match number 3. Cannot reference [SelectNumber]
This is a simple explanation for what will be more complex implementation. I have looked at setvariable but still cannot reference the variable in a query grid. Massive data macro examples on line confuse the h**l out of me.
There must be a simple solution for something that would be the bedrock of any decent system?
Have used Access desktop for many years.
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 13 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.
The Distinguished Expert awards are presented to the top veteran and rookie experts to earn the most points in the top 50 topics.