troubleshooting Question

Access 2013 web app use combo box value in query grid to filter records

Avatar of Paul Barrett
Paul BarrettFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft AccessMicrosoft 365
13 Comments2 Solutions2816 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Database Architect / Application Developer
Join our community to see this answer!
Unlock 2 Answers and 13 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros