Hi, I am having this problem. I want to reference a value on a subform in a report. I read the help info and this is what it says:

=Forms!Customers!Additional.Delivery

Customers = Main Form
Additional = Subform in Customers
Delivery = Combo Box in Additional

So in the report appears #Name

can someone help?

Check to see if Access is perhaps calling the subform something else, in addition to "Customers". I have been caught by this in the past.

HTH

Mike

Mike
EchoVue.com

so is there some way to do it or another way.

What I want is to use a print button to print what I see in the form, including Main Form and its subform. I don't care if I have to create a report and everything, I just need to print what I see.

Did you get the reference to the subform working?

A simple was to print the "what you see", you can create a report (and subreport- use the same queries as you used for the form and subform respectively). Then use the button wizard to put a button on the FORM, select report operations from the wizard, and select "open",...."report"....."then select the report name".

Reply back please if you need assistance.

HTH,
Loralee

If you're coding in the main form, you reference the combobox in the subform like this

Me.Additional.Form.Delivery

The "Me." is a shortcut for Forms!Customers. Also, to see what's on a form and subform you NEVER print the form. Always create a report and subreport to print records.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

thanks,

greg that was it.. to reference a subform in a main report i used

=Forms!Customers.Additional.Form.Delivery

and it worked perfect.