Multiple Forms Problem

  • Thread starter Thread starter Randal
  • Start date Start date
R

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?
 
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
 
That's it!!!

Thanks,
Randal
Rick B said:
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
Click to expand...
 
Back
Top