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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Edit the Macro that exists behind an existing Command Butto 2
How to use multiple command button to copy user form data to multiple worksheet 0
Access Automatically Send a notification email once a record is added 0
Add the command "Clear All Filters" to a Command Button in Access 2010? 0
Creating Command Buttons On The Fly 1
Access Manage Attachments linked to a SubForm 0
Access Command button to look up and copy data from a query to a table 0
command button for save 1

Back
Top