Date on report

[BorisGomel]

Hello to all of you,

I have a really small silly problem and it buffers me for a while .I hope you help me. It would be really appreciated. I work on very large data base that is a center peace of company and I created a report based on a cross query called qvrRejectFiles. Report is called rptReject. I put text box(txtDate) on form frmInqure Form . Also I put a text box on report and in property control source of text box and I put in there like this “=Forms! frmInqure Form!txtDate”.The report is run well , but the date is not showing up on report , is shows "#Name?". It is probably b/c there is a space in name of the form that is frmInqure Form , but I can not change the name of the form due to I have no authority to do that .How can i overcame this issue?
The best Reagrds,
GomelBoris

[Beetle]

Enclose the form name in brackets;

=Forms![frmInquire Form]!txtDate

[BorisGomel]

Thank you Beetle , but it doesn't work .It is not showing anything just blank space. I did as you told me .I put form name in brasket and it shows blank on report in text box not even "#Name". I am Still working on it.
The Best Regards,
GomelBoris

[Beetle]

Is the form open and does it have a value in the txtDate control?

[BorisGomel]

No I type date in text box and click command button .I am sorry here is more information how this works and what I would like to accomplish. The form is already created, I just added to the form the text box and command button. I type the date and click command button and based on the date the query qvrRejectFiles is run and the report rptReject is opened based on selection in the query. Everything is working fine. I placed a text box on top of report and in its control I put this "“=Forms![frmInqure Form]!txtDate.I would like to do that b/c there are lot of fields I need them in report for upper management, therefore the report in been printed in two pages. I delete date filed b/c it is the same for all records and put the date on the top of the report in order to fit everything in one page. The report is presented well better for upper management if all fields are to fit on one page.

[Beetle]

I'm not sure what your answer was as to whether the form is open or not when you are opening the report, but just to clarify, the form needs to remain open if you want to use this method. You can hide the form if you want but it needs to remain open.

[BorisGomel]

Ah ok, the form is remained open when the report is opened. The comand button coded to open the report only and no to close the form .
Thank you,
GomelBoris

[BorisGomel]

Hi Beetle,

Got it wokrs.Thousand thanks

GomelBoris