How to disable editing of only previous records in form...???

[khuram]

I want users should always add new records in form,,, can view previous
record but cannot edit/delete previous records. Any suggestion please......!

 

[Allen Browne]

I want users should always add new records in form,,, can view
previousrecord but cannot edit/delete previous records.

Set these properties for your form:
Allow Additions yes
Allow Edits no
Allow Deletsions no

 

[khuram via AccessMonster.com]

hmmm. this setting is good for a single form. but not working in form,
subform setting... plzzz suggest some solution.

regards!

 

[khuram via AccessMonster.com]

Add new record in main form does not fetch empty rows to write on in the
subform....

hmmm. this setting is good for a single form. but not working in form,
subform setting... plzzz suggest some solution.

regards!
[quoted text clipped - 3 lines]

Allow Edits no
Allow Deletsions no

 

[Allen Browne]

You're right: if the subform's AllowEdits is No, and the subform is on the
form, then it's one of the controls that cannot be edited.

What I actually do is to use the code in this link to lock only the bound
controls on the main form and subform:
http://allenbrowne.com/ser-56.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Add new record in main form does not fetch empty rows to write on in the
subform....

hmmm. this setting is good for a single form. but not working in form,
subform setting... plzzz suggest some solution.

regards!

I want users should always add new records in form,,, can view
previousrecord but cannot edit/delete previous records.

[quoted text clipped - 3 lines]

Allow Edits no
Allow Deletsions no