Restricting users from seeing any other records

  • Thread starter Thread starter Shannan Casteel
  • Start date Start date
S

Shannan Casteel

I have several dealers submitting warranty claims. I would like to set up
security so that there are ID's for each dealer and an ID that allows them to
enter claims. While logged on as the ID that allows them to enter claims, I
don't want to allow them to view any other records. If they are logged on as
their personal ID, I want them to be able to view the claims that they have
entered and no one elses. The number of dealers is constantly changing.

I think I might be able to accomplish the second part if in the On_Open Event
of the form I put something like RunCommand acFilterByForm. Then I would
have the DealerNumber field automatically populate by setting its default to
cmbDealerNumber = CurrentUser.

Anyone know if this would work?

Thanks for the help,

Shannan Casteel
 
This is adressed very often. go read the previous posts. Search for
"restrict own records".
 
Back
Top