How to show the value of criteria on query to report

[moi]

Dear All,

Can somebody help me how to show my criteria on to my report header..

I based my report on a query and fill the criteria (StartDate) and (EndDate) to "PDate" control from a form where i open my report..

I would like to display the value of the StartDate and EndDate to my report.. I tried to create a 2 textboxes and put an expression "=StartDate and =EndDate, but it displays no value (empty box)..

Thank you for any help..

 

[June7]

Oneway: keep form open and textbox expression references control on form.
=Forms!formname!textboxname

 

[ebs17]

DoCmd.OpenReport method (Access)

Office VBA reference topic

learn.microsoft.com

DoCmd.OpenReport ReportName, View, FilterName, WhereCondition, WindowMode, OpenArgs

You can use the OpenArgs argument to pass specific information to the report. Passing is then something very different from the point where the report itself should fetch the information it needs, and thus has a touch of object-oriented programming.

 

[GaP42]

If you construct your where clause in VBA, labelled as strCriteria, for example then you can pass this string to your report, placing it on the report where you like.
Technique explanation / sample database - from Allen Browne site: Microsoft Access tips: Search criteria (allenbrowne.com)

 

[theDBguy]

Can you please post the SQL statement for your query? Thanks.

 

[xavier.batlle]

Dear All,

Can somebody help me how to show my criteria on to my report header..

I based my report on a query and fill the criteria (StartDate) and (EndDate) to "PDate" control from a form where i open my report..

I would like to display the value of the StartDate and EndDate to my report.. I tried to create a 2 textboxes and put an expression "=StartDate and =EndDate, but it displays no value (empty box)..

Thank you for any help..

The report textboxes must refer to the form textboxes values. Their controlsource property must be:
=Forms!FORMNAME!StartDate and =Forms!FORMNAME!EndDate
(Change FORMNAME with the name of your form.)