automatically assign value to query

[cheekyblue]

Hello,

Ive got a database where staff login just using their name, and the login
button has a macro assigned as follows
Condition : Not IsNull([cboCurrentEmployee])
Action : SetTempVar
Arguments : CurrentUserID, [cboCurrentEmployee]

Certain contacts in my database are assigned to a member of staff and call
sheets are set up using a query that requests that member of staffs name. Is
there a way of automatically setting the criteria of the query to only show
clients that are assigned to the member of staff that has logged in?

Thanks, please let me know if i need to explain this further....

 

[cheekyblue]

doesnt matter, i've figured it out