Open a report based on a command line

W

warrior

Hi all,

I have a database in Access with the tables linked to a SQL database.
I have a report with several subreports that are based on the Customer
ID that is stored in a text box on a form.


I have users from a remote location that want to see their customer
information. I have a website where they can pick the customer from a
combo box. The ID is then passed to a command line (lets say SUBMIT)
which will pass the ID to the report in access. I have a macro that
executes the report.

I have moved the report and queries to a different mdb. Since I won't
be using the form that passes the Customer ID, I have put a text box on
the main report for the CustomerID.


Does anyone know how to reference the command line and pass it to the
report?

Thanks!
 
Top