I have a question to add to this. Is it possible to carry that user ID for that user as long as they are logged into the DB so that anytime the user opens a form or report (ie also query) that it filters the data for that user.

I know this can be done using the Access built in security but I am trying to get away from that due to the environment.

Thanks in advance

Christian