Richard/Team,

I have a Specialist Table, A Student Table and a Crossover Table that aids in tracking tutoring sessions (many-many) where each specialists can have several students and vice-versa. I am tracking each tutor session and drive a form that selects the Specialist and the Student in 2 seperate combo boxes with inputs for hours, subject and feedback then calculates sessions costs. Once this form is complete, I have  second form that is used for approvals. This form opens with the relevant information from the first form with all the aforementioned information and provides checkboxes and dates for Approvals.

All works spot-on as long as I use the two comboboxes to select Specialis/Student and the data carries over to the 2nd form properly for approvals and report printing.

But the to combo box selection is for Admin use only. When the Specialist logs on, they need only see their own info and the forms should populate with their info "automatically"

My intent:

Specialist's Input(problem form): Specialists logon and fill out their session reporting form. They would select student but not have to select themselves and the form/table would fill with their information only

Admin Input (current working form): Admin logs on selects Specialist and then student as well as hours, feedback, etc.

My issue is that I need to restrict the Specialist from seeing other Specialists names and information and want the Table/Forms/Reports to input their information "automatically" based upon their logon. So, I have TempVars setup at logon that specify whom is logged on using the architecture of your User Security (I believe from User Security Video #2). This works fine and I can reference the TempVars throughout the forms.

BUT I cannot set the Specialist's ID (UserID) or name in the form or table using the TempVars so that it will show-up in the record for that session in the table,subsequent Forms and Reports it is blank if I don't use the combobox. How do I set the value of the Specialist's ID (UserID) so that subsequent forms and reports will associate the Specialist's ID (UserID) with the relevant session? What am I missing? I have tried DLookup, placing the TempVars reference in OnLoad, OnOpen, etc. I am not getting it...The forest seems to be deep and I'm not seeing the trees...