Creating a Command Button

  • Thread starter Thread starter Yecenia
  • Start date Start date
Y

Yecenia

Hello, I need to create a form that shows information in a read only
fashion. However, I need a command button that allows the form to be edit.

How would you create this command? i know access, but not VBA coding.
Please help.

Thanks!
 
Why not set Allow Edits to No and then the command button to change it to
Yes.

You will also need to have On Close set Allow Edits to No.
 
Changing the setting to not Allow Edit is simple, but how would you create
the button that changes those settings to "yes"?

Would you create a Macro? I am not familiar with VBA coding.
 
I used your suggested code under a command button, but I got an error.

Please excuse lack of VBA skills, but does this command require two command
buttons?

I've been working closely with access since 2006, but I've never needed to
tap into VB or SQL until now. i appreciate your patience.
 
The code "Form_Current" is entered in the VB window for the form's current
event, the other code is for the command button click event...
 
Back
Top