Updating a form field after a subform event.

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
 
J

JohnR

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Set Change Event on Control from Nested Subform 0
First Subform record gets modified when closing form 3
Referencing a subform 4
setfocus on form control, not subform 4
create a subform without using the wizard 2
copy field from main form to sub form 8
Form and subform - timing of event triggering 4
Unremovable horizontal scroll bar on subform 1

Top