NOT ALLOWING EDITS IN A FORM

[Mksmall]

On my form , I have a search button so that you can call up a certain record number and look at it's information. The search is performed by a macro on the button. But I only want certain people to be able to change any information they see. If I allow "no edits" to this field I cannot do a search because Access won't allow any info to be entered on this form. How can I allow access to some( so changes and updates can be made) and to others who only need to see the information but cannot change what they see????

 

[JimHorton]

MKSMALL,
Some people have a local table with 'users' (different than Access Users), then they have a login form, where a user enters his 'user' name, and have a related table with forms, etc that they can use. Then if they have permission edit that form, you set the AllowEdits property to True or False, depending.

In my opinion, the best way is through Access' object-level security, set a Group for those who can edit and those who can't, and give usernames to your users and put them in the approriate group. This way, you don't have to worry about any fanagling with the form properties, and these permissions are system-wide, so the same data that they can't edit in a form, they also can't edit in a query, table-datasheet, or any other form with that data. It's a bit more work than the first way, but in the long run, it's better, in my opinion.
--Jim