Multiple Forms Problem

[Randal]

I am restricting users to their own data by creating a secured form for each
user. All data is in the same table and I only give the user access through
their form which filters for their data only. Is there an easier way to
restrict a user to records that contain their ID only?

 

[Rick B]

Yes, just use something like the following in the query criteria...


=CurrentUser()


This would go under the field which contains their UserID. Obviously, you'd
have to write their UserID to the record when you create them.

Rick B

 

[Randal]

That's it!!!

Thanks,
Randal

Yes, just use something like the following in the query criteria...


=CurrentUser()


This would go under the field which contains their UserID. Obviously, you'd
have to write their UserID to the record when you create them.

Rick B