Saving a record in the Form

S

SJ McAbney

I forgot to add that you can maybe have the button's
Enabled property initially set to False and Enabled the
button only when the current record is made 'Dirty'

i.e.

Private Sub Form_Dirty()
Me.cmdSave.Enabled = True
End Sub
 

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

When does record become dirty? 10
Control Bound Form Transactions 4
Hiding a button based on a value in a table 1
WORD VBA Search and switch to advanced ... 1
VBA word change keys 0
Dirty 7
How to Disable Undo Button After Each Click 1
Improving Macro That Keeps First Letter 0

Top