MS Access Sub Form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I am the new user of VB.

Normally, when users change/add/delete the data in the sub form, the data in
the original table get updated straight away. To prevent users change the
data by accident in the sub form, I want to add a Command Button with a
prompting message, "are you sure you want to saves the changes?" If the
users click OK, then updated. Also, I need to do the same for deletion.
Instead of deleting the record, I want to keep the record but flag for
"deleted".

Please could you give me some same coding.

Many thanks
 
Hi

I am the new user of VB.

Normally, when users change/add/delete the data in the sub form, the data in
the original table get updated straight away. To prevent users change the
data by accident in the sub form, I want to add a Command Button with a
prompting message, "are you sure you want to saves the changes?" If the
users click OK, then updated.
Click to expand...

In my experience, after the first ten minutes this button becomes useless
because the user will just click it mindlessly anyway. And it can become very
annoying for the data entry person - "Yes, dammit, if I didn't want to save
the changes I wouldn't be making them!!"

If you have two classes of users, one who should be making changes and the
other who shouldn't, consider having a "read only" form for the latter group.


John W. Vinson [MVP]
 
Back
Top