keep getting $NAME?

[disgruntled]

I have a form in which the user enters a bunch of criteria which is passed along to a query and that to a report. In the header of the report i have various textboxes stating the criteria values. I did this by setting the control sources.
eg. =[Forms]![frmReport_Char]![cbox_status]
but all i get are $NAME? in the fields???

Also, I click a button on the form which does all this using these 2 commands: Domd.OpenQuery ("qryReport_chars")
DoCmd.OpenReport "rptChar", A_PREVIEW
The query window opens but i do not want the user seeing this. Is there a better way to do this?????

Thanks a million for any advice.

 

[Rich]

Base the report on the query, you do not need to open the query just the report, that may be the reason your report does not see the form fields, assuming the references are correct and the form remains open while the report opens.
HTH

 

[disgruntled]

Thanks.....your absolutly right about not opening the query and you were also right about the values (stupid error in form name which I c&p to all of them.)
Thanks again