Display Control Date from form on report 1

[Cillies]

Hi! All

I have a form, from which I can pull reports by client and date range.

The thing is that I need to display the two between dates that I enter in the form so as they display on the report.

Hope some onr can help

Kindest Regards
Cillies

 

[KenReay]

Hi

Provided the form is still open when you run the report you can reference the controls on the form using the syntax:

Forms!MyForm!MyStartDate

so you could put a control on the report with the source set to =Forms!MyForm!MyStartDate, or you could write code in (say) the Page HEader fornmat event to refer to the form



Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Cillies]

Thats brill Ken works a treat. And so simple.

Kindest Regards
Cillies