Only display data for logged in user (1 Viewer)

[connieharper]

I have a database that uses a logon form for the user name and password. The users are students. After the student logs on he/she will see a form that contains options of printing a variety of reports. When they print the report I want only their data to be printed. How can I accomplish this?

I have a table that contains all the students names and id numbers (student record) but when the student logs on the form uses the data from a different table "USERS" to verify the LOGON. These two tables are not related.
The data in the tables that the reports print from contain the student id number from the student record not the userid from the USER table. Most of the students use the same USERID to logon with but all have seperate student id numbers. Without completely redesigning the login process, how can I relate the two tables so that the reports know what the student ID number is by looking at the user that logged into the computer?

 

[Anauz]

I presume you want to access the windows current user...via the windows logon?