Report from a subForm

  • Thread starter Thread starter Bruce Rodtnick
  • Start date Start date
B

Bruce Rodtnick

I have a report that is getting its information from a subForm based on
the record on the accompanying form. This worked great when I just had
a main form (DVCam) and a subForm (Clips). I used the criteria
[Forms]![DVCam]![TapeID] and it would bring be everything for that DVCam
record.

But now I put the original form (DVCam) into another form as a subForm
(subDVCam). So now I have a main form (Projects), with a subForm
(DVCam), and the subForm has a subForm (Clips). I want to print a
report of Clips based on the record that is active in DVCam but I'm
getting ENTER PARAMETER VALUE [Forms]![DVCam]![TapeID]. What am I doing
wrong?

Bruce
 
HA! Got it! [Forms]![Projects]![subDVCam]![TapeID]. I guess it took
putting it all in words to figure it out in my mind.

Thanx until next time.

B
 
Back
Top