password protect a form

[pdtit]

Hello,

I was wondering how to "password protect" a form in my application, based on a table "users" which contain username and password.

At first, opening the form as read-only is fine; however, is it possible in this scenario to "block" certain fields from editing based on which user logs in ?

Regards,

Peter

 

[Remou]

Hi
As in:
If Forms!HiddenUserForm!AllowedThisField = False
Me!ThisField.Enabled = False
End If

 

[ZmrAbdulla]

I'd suggest to use userlevel security to protect the DB.
TOOLS > SECURITY >......
You can find a some information about Access Security Overview & with Microsoft

________________________________________
Zameer Abdulla
Visit Me
Hold your child's hand every chance you get.
A time will come when he or she won't let you.

 

[FancyPrairie]

This thread thread181-1026600 also explains how to setup security step-by-step.