My query doesnt seem to work

[shabbaranks]

Hi All,

Im trying to create a generic query which will pull data from a table based on the logged in user. I have a module which pulls in the windows username but cant seem to get the query to work - it just pulls in all data from that table. If I use the criteria which is assigned to that field "sUser" it gives me a blank result obviously as there are no users called sUser.

Any ideas?

Thanks

 

[vbaInet]

You need to put the name of the function in the query:

WHERE UserName = UserNameFunction()

 

[shabbaranks]

Thanks, worked a treat.

 

[vbaInet]

You're welcome shabba!