Could someone please guide me on the VBA syntax to load a query that then filters records when my form opens? Right now I have to double click the form to open and then manually load this query from the "Records" menu in the toolbar and then apply this query as the filter to my form. I am basically trying to automate this task so that when the form opens, the query is auto. loaded and applied as the filter. Thank you.
can't you not just use the query "z supplier qty adjustment filter" as the recordsource of the form "z supplier qty adjustment"?
then open the form "z supplier qty adjustment" from form [z filter] after
The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string.
Specify the first argument, which is the expression to be returned:
Specify the second argument, which …