SubForms - data entry updating

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

Guest

I am using a Main Form with 2 sub forms to make data entry.
When I correct a (Child/Parent) linked field in the Main form - it closes
the subform record without updating.

I need to be able to update the Subfroms from the Main Form, and expected
that any changes to data in the Main Form would automatically update the
Subforms. I am sadly dissapppointed.

How can I update subforms from the Main Form ? Is it possible ?
 
from Rainbow01 Hong Kong

u need requery the subform

e.g. assume u have a button in mainform
after u update in mainform, click this button for saving:

in this OnClick Event
Me!YourSubFormName.Requery

"Glynn" 來函：
 
Thanks Rainbow, but I still have a problem.

I put a REQUERY button on the MainForm, and it does update the SubFrorm with
all the changes made to the mainForm - BUT only for a new record.
In my SubForm I have two fields for data entry in addition to the other
fields drawn from the MainForm.

When I 'Requery' after making corrections to the MainForm, the existing
SubForm data record (with the two new entered fields) becomes a record. I'm
trying to update this SubFrm record with the MainForm changes before it
becomes a record.

Am I attempting the impossible, or is there some other Property in the Forms
that I have not correctly set. I have the 'Data Entry' Property in both
forms set to NO.

Appreciate any help.
 
Back
Top