Use Varibales in a query with VBA in Access 2010

[Matze0710]

Hello guys,



I need to use a varibale in a query, because a person needs to lookin into a screen and after that the person shoudl see his/her query depending on his user account.

Where do I need to store the variable and how can I use the variable in a query?

Best regards

Matthias

[orange]

How about stepping back and describing in plain English WHAT you are trying to accomplish?
No jargon -and don't assume we can guess what you're talking about. Details and an example would help readers to put your issue into context.

[pbaldy]

If you mean a VBA variable, you can't use it directly. Create a public function that returns the value of the variable, and call that from the query.

[June7]

Users should not even see much less work with tables and queries. Apply filter criteria to form or report.

I store user's login ID on a form that never closes (such as MainMenu) then it is always available for reference.

This is a split database?