you'll need to use vba
investigate Environ("username") - this will return the windows login name for the user currently logged in
you'll need a public function in a module
Code:
Function GetUsername() as String
GetUsername=Environ("username")
end function
then your query will be something like
SELECT * FROM myTable WHERE username=getusername()
so you will have in your table a field called username and as new records are created you will need to populate it - to do this put this code in the beforeupdate event of the form
Code:
username=environ("username")