How can I filter data with twwo criteria from two different forms

We have a database that consists of the following:

Table of salespersons: tblSP
Table of Date Ranges: tblDR

Report1      Item Sales information:      rpt1
Report2      Customer Sales Information: rpt2

Form1      SignOn form with ID and Password
Form2      Basic Info

We would like the signOn form to first appear giving the salesperson (tblSP) the opportunity to sign on by selecting his or her name from a pull-down.  The salespersons name is captured and all files not associated with the salesperson are filtered out.

Next the switchboard appears and requires the user to select a date range from a pulldown.

The user then decides to print a report of to update the data.  The program has filtered the files where only the ones prepared by the user (tblSP) and created during the range selected (tblDR) will appear.  The user will only see records associated with him or her.  All reports will show all records but updates will automatically be limited to those associated with the user and covered during the date range selected.  This will allow the reports to show everything but the user can modify or delete only their records.

All of the above has been created and is ready EXCEPT, I dont know how to capture the Users name and date range for filtering or querying.  Please help with setting up the filtering or query process.
Start Free Trial