Updating a form field after a subform event.

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

Guest

I have 2 tables A and B in a 1:M relationship. Form A has data fields and a subform B. When I update a row in the subform B, I use the 'After Update' event and update a field on form A no problem, but I need to save the record on form A before the user can Hit Escape and I lose the A record data. So how can I force record A to be saved. Thanks
 
formA.Requery
-----Original Message-----
I have 2 tables A and B in a 1:M relationship. Form A has
Click to expand...
data fields and a subform B. When I update a row in the
subform B, I use the 'After Update' event and update a
field on form A no problem, but I need to save the record
on form A before the user can Hit Escape and I lose the A
record data. So how can I force record A to be saved.
Thanks.
 
Back
Top