connecting datasheet Subform

[Guest]

Hello Access experts:

I have a problem connecting my subform to the main form for every entry
entered. I have frmSubItem (datasheet form) as a subform of frmSubCalculation
(single form), frmSubCalculation is in the main form frmRGA. Somehow
frmSubItem does not refresh when I start a new record, it still has the old
data that I entered for the 1st record. All the tables are connected using
RGAID back to frmRGA, so I am not sure why frmSubItem doesn't work properly.
Is it because it's a subform of a subform and I just didn't connect them
correctly somehow?

Thank you.

 

[Larry Linson]

The LinkMasterFields and LinkChildFields for a Subform Control refer to the
Form in which the Control resides, and the Form embedded in the Subform
Control, respectively. Is that what you have specified in your nested Forms
and Subform Controls? It was not crystal clear to me from your question --
"connected using" requires assumptions.

If you use LinkMasterFields and LinkChildFields as intended, for the Subform
Controls in both, they _should_ all be synchronized.

(There are other ways, e.g., in VBA code to synchronize, but it is easy to
make a mistake if doing so, and would require a very detailed description of
what you have coded.)

Larry Linson
Microsoft Access MVP

 

[Guest]

Hi Larry,
I connected the tables (RGA ID) in Relationship using 1 to many relationship
and then when I go over and check the subdatasheet in the main table, the
data entered on the form was not recorded. So I just assumed that there is
something I missed while trying to link these tables.

 

[Larry Linson]

I don't use "subdatasheets," so think someone else will need to pursue this
question with you. IMNSHO, subdatasheets are a violation of relational
database design principles, and such violations often cause difficulties
when the user attempts to go beyond the novice level of working in straight
datasheet view. That may be what you are experiencing, but I couldn't say
for certain. I'm sorry I am not able to be of assistance.

Larry Linson
Microsoft Access MVP