I have a database where I have a login form and a variable stores the user which is logged in. Certain Forms I set the Allow Additions, Deletions and Edit to NO. I created code which on Open would check the user variable and if the user is allowed to modify I set the Allow Edits to True. My issue is with the restricted users, I want them to be able to browse the data. I have Combo Boxes to enter info to pull up records but they are unable to type or click on these drop downs which I suspect have to do with the NO I set on the form.
How can I keep them from modifying the records but still allow them to use the Combo box.
Thanks
Sam