Open Form view based on Sign in

[MdHaziq]

Hello


Forum,

I am trying to get my button, frmDesc, in my frmMaster to open based on login info.
I would like those who are able to login to be able to edit the info in frmDesc.
Those who click on the other button in frmLogin to only view the data in readonly mode.

Is this possible?

Yours Sincerely,
Haziq

[June7]

Why would you give user option to open read only or not read only? This should be your decision based user profile. Have a field in user table that classifies user. I use categories like Developer, Administrator, General.

Review https://www.accessforums.net/showthread.php?t=23585

[MdHaziq]

Those who are in the tblEmployees are ICs that have full power of the Db.

The rest are men who can only stock in or withdraw via frmLog

[aytee111]

You need to carry a setting on a hidden form which states that the user clicked on read-only. Then open the form with DoCmd.OpenForm "frmDesc",,,,acFormReadOnly

[June7]

So you have user who would not be in the tblEmployees and therefore would not have a login and password? So instead of entering a login ID and password they would just click button?

Don't really need two buttons for that. Just one button and code checks if login and password are blank, just open form read only.