How-to postpone record update on subform until command is clicked?

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

Guest

Hello,

I have a subform in datasheet view with a locked fields and editable yes/no
field and date field. Using the BeforeUpdate event, I can get the current
date into the date field when the yes/no field is checked. However what I
really want is to have the user check as many records as needed and then
click an update command button to add the current date to the date field (I
don't want the record updated after navigating away from it).

Any help is appreciated.

TIA. Allan
 
KonaAl said:
Hello,

I have a subform in datasheet view with a locked fields and editable
yes/no field and date field. Using the BeforeUpdate event, I can get
the current date into the date field when the yes/no field is
checked. However what I really want is to have the user check as
many records as needed and then click an update command button to add
the current date to the date field (I don't want the record updated
after navigating away from it).

Any help is appreciated.

TIA. Allan
Click to expand...

Can't be done with a bound form. When you leave an edited record to go to
another record the dirty one is saved. There is only an edit buffer for ONE
record so that is how it must be. The closest you can come is to bind the
form to "work tables" and only save the changes to the real tables with
queries when your butotn is pressed. A lot of work for no benefit.
 
Thanks Rick -- that's what I thought but wasn't sure when I started reading
about the dirty event.

The problem I'm faced with is that the date field gets populated if the
check box gets unchecked -- that is the user checks it yes and then decides
it shouldn't be checked. I've tried coding the beforeupdate event with an
If, Then statement without success to supply the date with checked yes and
blank when no(I've since deleted the code so I can't share that with you).

So I'll try again. Thanks!

Allan
 
Back
Top