Using Access 2007
Windows 7
Have 6 different reports open from a form.
Each report is using a site parameter selected from a previous login form that will select a site with the correct password
Originally reports and site selection were all on one form and reports generated correctly selecting the site and using the criteria in the query.
The need is for the site to be password protected. I created a login form with filed Site and field Password. I got it to work correctly and it opens the report form with all the different reports.
However, the reports do not work with the query criteria of site anymore...
This is the query running the report
SELECT [Client Table].ClientID, [Client Table].Site, [lastname] & ", " & [firstname] AS NAME, [Client Table].SvcReq, ServiceList.AmtRcvd, [Client Table].Zip, [Client Table].YrlyIncome, [Client Table].[Intake Date]
FROM [Client Table] INNER JOIN ServiceList ON [Client Table].ClientID = ServiceList.ClientID
WHERE ((([Client Table].Site)=[Forms]![Frmsiterptlogin]![cboSite]));
TIA.
Windows 7
Have 6 different reports open from a form.
Each report is using a site parameter selected from a previous login form that will select a site with the correct password
Originally reports and site selection were all on one form and reports generated correctly selecting the site and using the criteria in the query.
The need is for the site to be password protected. I created a login form with filed Site and field Password. I got it to work correctly and it opens the report form with all the different reports.
However, the reports do not work with the query criteria of site anymore...
This is the query running the report
SELECT [Client Table].ClientID, [Client Table].Site, [lastname] & ", " & [firstname] AS NAME, [Client Table].SvcReq, ServiceList.AmtRcvd, [Client Table].Zip, [Client Table].YrlyIncome, [Client Table].[Intake Date]
FROM [Client Table] INNER JOIN ServiceList ON [Client Table].ClientID = ServiceList.ClientID
WHERE ((([Client Table].Site)=[Forms]![Frmsiterptlogin]![cboSite]));
TIA.