Edit Record Command

[jenniferspnc]

I've been doing a lot of reading and found out that an edit record command is
the best option to keep users from accidentally deleting data in the form. I
right-clicked in the general area of form and set all properties for edits
and deletions to No. I left additions as Yes. And that works, I tried
editing a field and it wouldn't allow me.

The problem is the command to edit doesn't work right. I put "event
procedure" on Click but I don't think I've found the right code for editing.
Can someone please help me with what to do to allow editing of records when
the user clicks on that command button? Thanks in advance.

 

[Stockwell43]

Hi Jennifer,

Ok, on your forms button to allow edits place this code in the On Click Event:
Forms!yourformname.AllowEdits = True

Where is say Yourformname, replace it with the EXACT name of your form. In
otherwords, if your for name is frmDataEntry, you need to make sure you add
the frm as it is part of the name.

 

[Tom van Stiphout]

On Fri, 21 Mar 2008 09:55:01 -0700, jenniferspnc

Me.AllowEdits = True
-Tom.