Need Sub-Form on Continuous Form?

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

Can this be done and if so how or if not suggestions on something else?
I have a Check Register that I use to input Checks and Deposits and I need a
way to include multiple Deposits for the same Depositor, i.e the sub-form.
The Check Register is a Continuous form.
 
Can this be done and if so how or if not suggestions on something else?
I have a Check Register that I use to input Checks and Deposits and I need a
way to include multiple Deposits for the same Depositor, i.e the sub-form.
The Check Register is a Continuous form.
Click to expand...

You can't put a Subform on a continuous form... but you can put two
subforms side by side, and have one of them dependent upon the other.
Set the Master Link Field of the deposits subform to

[Forms]![mainformname]![Registersubform].Form![CheckNumber]

You need the complete forms reference, using the name of the form, the
subform control, and the linking field on the subform.
 
Back
Top