Form/subform strategy help needed.

[Acanthocanis]

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.

 

[Klatuu]

There are a couple of ways to do this. Which you use depends on how you are
structuring your recordsets and personal preference. Both use arguments of
the OpenForm method. One is to use the Where argument. It will limit the
recordset of Form B based on the Where condition. The other is the OpenArgs
argument. Pass Form B a value that it can use in the Load Event to point to
a specific record or to set it's filter.