Desicion Making - One Form - Multiple Query

[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?

 

[Albert D. Kallal]

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