Restricting access to a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The form(employee) that am working on is based on a table(tblemployee) that
has employee information, it also has a subform.. The form also has a
combobox that an employee can select there names and enter productivity. The
following filter is on the main form [EmplID] =
[Forms]![tblemployee]![cmbSrchEmpl] and I put the same code on the open form
as an event procedure. This way when the form is opened, its blank and you
cannot see anything apart from the unbound comboboxso when one selects
his/her name, then you are able to view the subform!

so anyway how will I use the =current user() when my form is based on a
table and not a query?

Thanks for you help!
 
Answered in your other post.

Base your form on a query and limit the records in the query to only display
those for the current user.

No need for a combo box if the user can only make one selection from it. Get
rid of it.
 
Back
Top