Report From a Form with a Subform

[sondriven]

I have a form with a subform inside. I need to make a single report from this record.

What do I need to do to start this?

Thanks

 

[Rich]

Saving the form as a report is a good place to start

 

[sondriven]

Thanks Rich,

I rearranged the looks of the report.....to look more like a report.

How do I make a macro to open the report thats based on the form (record) that Im currently in?

So far the report lists all of the forms.

 

[Rich]

Either reference the control in the reports underlying query, or look up the OpenReport method in help. Much better to get your feet wet with vba now and dump macros

 

[sondriven]

I made the report from a form. I dont have an underlying query for this. Is it still possible to do this? And not have to design the report over?

In the query, what do I put in the criteria to make it print the selected report?

Thanks.

john

 

[Rich]

It's actually easier to use a query and set reference to a form control, a method I've always found to be faster than using the where clause of the open report method.
Providing all the fields on the report are in the query then switching the control source to the query shouldn't affect the report.
If you use the code builder on the criteria line for the field you wish to filter on then the form references should be set correctly.
HTH

 

[sondriven]

I got it to work!

I used a macro, please dont slap me. But I used a where condition and when Im done entering data into the form, I made a button to reference the macro and it works great. The report for that form pops up.

Thanks all for pointing me in the right direction.

john