J
Jesse via AccessMonster.com
I have a database (Supervisor DB), on this database there is a form. On this
form there are several command buttons. Each command button is hyperlinked
(through VBA) to a second database (Master_Shipping_DB). The second database
is where all the queries and reports reside. I have 9 reports that need to
look at a text box for criteria selection. In the second database I have
created a form, this form has two text boxes on it. When I press the command
button on the first database I can make it open the second database and pull
up the form with the two text boxes. The problem I am having is, how do you
continue the VBA with this new selection criteria and the form to know what
report to pull up. I hope this all makes since. It is pretty hard to explain.
Any suggestion please let me know. Thanks
form there are several command buttons. Each command button is hyperlinked
(through VBA) to a second database (Master_Shipping_DB). The second database
is where all the queries and reports reside. I have 9 reports that need to
look at a text box for criteria selection. In the second database I have
created a form, this form has two text boxes on it. When I press the command
button on the first database I can make it open the second database and pull
up the form with the two text boxes. The problem I am having is, how do you
continue the VBA with this new selection criteria and the form to know what
report to pull up. I hope this all makes since. It is pretty hard to explain.
Any suggestion please let me know. Thanks