add but not edit records

[gmacg]

Hi, What can I do to allow a certain group of users to add records to a table, but not edit them? I have a subform that opens with certain options visible according to the group to which the user belongs. The form works great, but it seems that no matter what I do, I can't set the subform to allow additions, but not edits. I also need to allow other groups to be able to edit the records. Any suggestions?

 

[Blorf]

Well, first thought is to set the form to Data Entry, so existing records are not available to the users in question.

ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[gmacg]

Yes, it seems that would be the first option, but it didn't work. The user picks an employee name from a drop down box on the main form and the subform opens to the record selected from the main form. If I set the subform to DataEntry, I get a datatype mismatch error.

 

[Zion7]

So the subform is for viewing, And Adding records then?

I would have a button to select
Me.Subform.Form.DatEntry = True.
When desired.
Obviously, you can't navigate thru records, while in DatEntry mode. So it's one or the other.
When you press another button "Save", then,
Me.Subform.Form.DatEntry = False

 

[JerryKlmns]

You do have user-level security in place, don't you?
Grant Insert Data and Revoke Update Data for that group on your table

 

[gmacg]

Yes, I have user security. That's what is so strange. I did exactly what you said Jerry, but it didn't work. I'm not at work today so I won't be able to tell you exactly what happened. I'm hoping my day off will allow me to look at it with a fresh eye tomorrow. I've been struggling with this for days.