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.
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.