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.
Most examples I see is where Microsoft suggest you py the actual value in the query like Today() or Between 1 And 10. This is too basic for any app that needs to give flexibility where what you are seeing is what you asked for from a form interface.