Report from a subForm

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
 
B

Bruce Rodtnick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Controlling printed records when report bound to multiple tables 0
Run Report of Current Record of Subform 4
Creating a report from a tabbed form 1
Can I save a sql statement generated by a search form? 1
Errors in Report total fields 19
report/subreport 11
Order Totals (From Expression) on summary report 0

Top