Filtering using a temporary count variable

[jun90]

Hi all.

May i know is it possible to filter records from a table using vba?

I am doing a program whereby when the user type their login name and password and click "Login", the program will reference to their userID and they will be presented with their OWN records only. how do i filter off all those other records?

This will temporary save under the query, as it is impossible to manually filter all the users' database 1 by 1.

 

[pbaldy]

You can base a form on a query that has a criteria. That criteria could point to the login form where the user has entered their login, or use CurrentUser() if you're using the built-in security.