Submit Button Accepted Indicator

Z

Zack Mayo

Newbie!!

I have created a simple form with 7 fields to enter data. I have also added
a Save Record button to hit when data has been entered. I need there to be
some indication to the user that the data has been saved to the table. Is
there a way to do this? Right now you hit Save Record and it appears nothing
happens though the data has been written.

Thanks,
 
W

Wayne Morgan

There is a built-in indicator. If you have Record Selectors set to Yes in
the form's Properties sheet, the icon on the selector (left side of the
form) will change from a triangle arrow to a pencil when the record is
dirty. It will change back again when you cancel or save the changes. If you
want to do this another way, you could pop-up a message box in the form's
AfterUpdate event.

Be aware, that unless you've done something to prevent it, Access will save
the record automatically when the record loses the focus, such as when you
move to another record.
 
L

Larry Daugherty

Unless you have gone out of your way to fiddle with the form's
properties, simply navigating off the current record will cause any
changes to be saved. No special command button is required.

HTH
 
Top