Applying filter with selected field based on another field

[nancypez]

I have a login screen to open a form. I would like to filter the form based on what user logs in.


In my tbluser, I have a trainer name, a UserLogin, and a password. I would like the form to filter on trainer name based on userlogin.

I know the code: DoCmd.ApplyFilter , "Trainer = 'Joe Smith'" but how to I edit the code to change as the tbluser changes?

Any assistance with this would be greatly appreciated. I am new to coding and am enjoying learning as I go but still seem to get stuck at spots.

Thank you.

[ItsMe]

...how to I edit the code to change as the tbluser changes?...

You don't edit the code. Are you familiar with Primary Keys? Your tables should have relationships with other tables. Use the relationships and query the relative data you want to retrieve.