how to create an unbound form that uses a different query depending 1

[jsanbor1]

on the current user.

I am using Access 2000 with the built in security.

We need to control what contact each user is allowed to see and this seems like it might be a good way to do it. That way we can modify the users query as needed if he needs to see more or less contacts.

If current user = jack smith, then use qryJackSmith to open the form. (I would love to put in a piece of code that I've started with here, but I don't know where to start.)

I am new to using unbound forms, but I'm hoping that this is a simple problem, even though it was been giving me such a headache.

 

[Crowley16]

the relevant bit of code is:

Form!FornName!ControlSource = 'qryName/tableName'

--------------------
Procrastinate Now!

 

[jsanbor1]

thanks

what about the current user part though?

 

[PaulF]

set the recordsource during the Form's On Load Event

Me.RecordSource = "qry" & Environ("username")



PaulF