Ok... I have a database I've been working on extensively. I recently ran
across an issue where refreshing records causes a stack memory problem and
the program crashes. I had one main form with 5 subforms . The fifth subform
then had 3 more subforms. There are no additional forms or subforms. I have
tried creating a 'wizard' type series of forms to input the data for each
subform separately (so a smaller number of forms/subforms are open
simultaneously), but for whatever reason, I cannot get one form to pass the
linking field's data to the next form, most likely because at that point,
there are no matching records existing for any of the tables upon which the
subforms are based. For example, I've tried having FormA create records for
ParentTableA, then close FormA when finished to open FormB, which contains
the primary key from ParentTableA, then a subform for table ChildA. However,
I can find no method that opens FormB with the desired record added using
FormA. I could manually type in the linking data, but surely there is a way
to make this work automatically.