Update second field when 'on enter'

  • Thread starter Thread starter shawnews
  • Start date Start date
S

shawnews

When I enter 'AmtPaid' I would like to have 'Datepaid' automaticly show and
also the 'Amtpaid' sum execute without waiting until I move to the next
record.

Any help will be appreciated

ArtCav
 
Using the AfterUpdate event of the AmtPaid Control:

me.DatePaid=date
me.dirty=false

The summary field (calculated) is not getting updated because the record has
not been saved. The second line will force the record to be updated which
will then allow the summary field to be updated without leaving the record.
The downside to this is that the user will not be able to undo changes to
the record after this control has been updated forcing the subsequent update
of the record. You might want to consider this before you implement it.
 
Back
Top