Sure. How are you storing the username? Global variable? TempVars? Form Field? Just use that in your query.

I show how to do this in my Access Security Seminar.

Currently only in the user table

Sounds like you need a "parameter query."  Richard has a free video on the basics of it.  My picture shows what a parameter looks like in design view.  You run it, and it prompts you to *manually* enter a value for the parameter; in this case,the value will be used as the criteria.  In my example, the parameter is called [country name contains], which must be a unique name enclosed in square brackets.  "Unique name" means it is not used anywhere else inside this particular query.

The above method only accepts a manual entry.  To pass something from a table, you need VBA.  First you need to look up the value with, say, DLookup().  Then you pass that value to the query's parameter with my sample VBA code below.  (I don't know if Richard has a video using parameter queries in VBA or not.)  The syntax is fairly simple, but you need to be proficient in using Recordset and QueryDef in VBA.  And note that NO square brackets are used for the parameter name here (i.e. "country name contains").  This code will yield a Recordset "r" that contains the result of the query.

Thank you Kevin, I will try this :)

Thank you I'll try that :)