I have a query that allows the user to input the parameter and returns records on that basis.
This works fine and displays the results on a form. What I want is to display the user input on that form so if the user has multiple iterations of the form open they know which results set corresponds to which search.
I've looked into running the SQL in VBA and storing the input as a variable which is printed to the form but I don't know if this is the best way.
Can this be done in SQL alone or does it need VBA and/or a Macro?
Appreciate any suggestions.
This works fine and displays the results on a form. What I want is to display the user input on that form so if the user has multiple iterations of the form open they know which results set corresponds to which search.
I've looked into running the SQL in VBA and storing the input as a variable which is printed to the form but I don't know if this is the best way.
Can this be done in SQL alone or does it need VBA and/or a Macro?
Appreciate any suggestions.