Desicion Making - One Form - Multiple Query

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

Greetings...

I have a data edit form. I would like to code a script
that will check who the CurrentUser() is, and then
populated the form with the information pertaining only
to the user.

I know i could create various forms linking to the
specific data, querying the master table for each user.

but i would like to have only one form for everyone, and
for the sytem to populate the form based on that user.

any ideas of the approach on this?
 
The code to open the form with just records for that user would be:



dim strWhere as string

strWhere = "UserField = '" & currentuser() & "'"

docmd.OpenForm "the form",,,strWhere
 
Back
Top