Allow dropdown (search) selection when user permissions are read only (allowedits=false)

**Gina Maylone** · 02-03-2022, 08:36 AM

Hello everyone! I have setup a little login/permissions function in a db. If the user's level is 1 then they cannot edit the record, but I need to allow them to search for a record via a dropdown box. Any thoughts on how I can do this? Thank you in advance!

**ranman256** · 02-03-2022, 08:49 AM

use the level to open the form as readonly:

Code:

IF vUserLevel = 1 then
   docmd.OpenForm "frmEdit",,,"[id]=" & cboBox ,acFormReadOnly 
else
   docmd.OpenForm "frmEdit",,,"[id]=" & cboBox 
endif

**Gina Maylone** · 02-03-2022, 09:05 AM

Hey Ranman! You lost me with that one. I don't get the purpose of ""[id]=" & cboBox " Thanks!

**Gicu** · 02-03-2022, 09:14 AM

For level 1 you can set the form's RecordsetType to snapshot which will render the form read-only but allow the unbound combo(s) to do the search.

Cheers,

**Gina Maylone** · 02-03-2022, 09:26 AM

Perfecto! Thanks so much Vlad!!!

**Gicu** · 02-03-2022, 10:20 AM

You're very welcome!
Cheers,

Allow dropdown (search) selection when user permissions are read only (allowedits=false)

Thread Tools

Allow dropdown (search) selection when user permissions are read only (allowedits=false)

Similar Threads

Button on form A to open form B with subform -- with subform AllowEdits = False

Checkbox True/False based on Dropdown Selection

First user allow to read and write, 2nd user only allow to read

How do I set permissions to read all tables in access database....

Form combo box not working with AllowEdits = False

Tags for this Thread

Posting Permissions