Querying tabbed subforms

[tempk]

Hi all,
I have a main form with tabbed subforms(all based on different tables) where I want to display only the records the specific viewer is able to see. I know that I need to change the record source for the subforms based on the criteria of filter I want but somehow I'm lost in the syntax.

Help?

Thank you!

 

[tempk]

another note

I am currently using a query with a criteria based on a textbox which gets its value from user's input on which department he is from. I'm trying to cut down the number of queries used...So a dynamic flter would be best, I think.

Any suggestions would be fine!