printing from form and subform

[zxmax]

Greeting all

I'm tring to print from a form that has subform ..

In my main form i have couple of feilds that do not exist in the table , eg: i have a feild that looks like this : =[Financial Subform1].[Form]![PedyCashTotal] ==> where Financial is the subform , and pedyCashTotal is a formula in the subform header ..

Now when i go to the report wizard, it only allow me to add feilds from table and/or querys, as of these extra feilds i created in the form do not exist ,

How do i add these feilds in the form and subform to the report ?

Any help , resource will be greatly appreciated,

 

[dhookom]

Either summarize the subform records in a total query that can be joined to the record source of your main report or add a subreport that is very similar to your subform. You can then use similar syntax.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.