Using criteria

[gpurger]

I have a report which is filtered using the following criteria on a query
<=[Deliverables upto T0+ date]
How can I get the user input displayed on the form?

Cheers

Gordon

 

[directormac]

Not sure from your post exactly what you're after, but it sounds like you want a text control on a form that also has a button on which generates the report based on whatever criteria the user has typed into the text control?

If so, add the text control, give it a meaningful name, then in the query which serves as the source for your report, edit the criteria to something like:

= Forms![frmMyForm]![txtMyControl]

Use the builder to make sure you get the reference correct.


The Northwind sample database has an example. Look at the "invoice filter" query (something like that), called from a command button on the Orders form.

--Filtering Mac

 

[gpurger]

Thanks for that, very useful, all ready added.

Regretfully this is the wrong problem. My fault, did not explain properly.
What I want is to display the inputed data in the report heading. e.g.
"Report up to and including"&" "& [T0+]

Cheers

Gordon

 

[directormac]

You should be able to refer to the contents of a control on a loaded form in your report header. Create a text box in the header of the report and set the data source to something like:

="Report up to and including:" & Forms!frmMyForm!txtMyControl

Make sure the form is open when the report is opened. If you encounter a snag, trying making the control on the form in the form's header section, rather than the detail section, and is unbound.

--Rusty Mac