Edit Record Button

A

AccessTester1

I am a newbie to Access. However, I have found almost all the buttons and
it's related codes, i.e., Add record, delete record, save record, with
respective code, i.e., RunCommand.AddRerocd, etc.

What I can't find anywhere is "Edit Recod" button. Nor any command, i.e.,
RunCommand.EditRecord or Do.Cmd, , , EditRect etc.

When form load and opens I want record not in edit mode. so the record that
is displayed on the screen is view only. If user presses "Edit Record"
button then I want to put the displayed record in "EDIT" mode and allow
changes.

It so simple, yet, I can't seem to figure out. By the way I am not using
query in the form. I created form using wizard and I chose table instead of
query in the wizard.

Please help.
Thank you,
AccessTester1
 
S

Shane S via AccessMonster.com

In the Edit cmdButton, On Click Event, you could put:

Me.AllowEdits = True

This should allow your users to change from read only to being able to edit
the record.

HTH,
Shane
 
J

JamesJ

In design view of the form set the AllowEdits property to No.
Then create a command button and set it's Caption to Edit Record.
On the OnClick event of the button insert

Me.AllowEdits = True

Hope this helps.

James
 
A

AccessTester1

Thank you JamesJ and Shane S. I will try that out.

Regards,
AccessTester1
 
Top