Get record from subfrom and put it in a report header

[abolos]

Salut,

Suppose I have frmA and subformB inside frmA. I have a button opens a report rptA based on subformB. In this report I have txtA and textB. In subformB I have date

01/01/2007
12/02/2007
03/03/2007
28/05/2007

I want to have the txtA and txtB in rptA the MIN and MAX dates in the list above. This means that txtA in rptA must contain 01/01/2007 and txtB in rptA must contain 20/05/20007.

Actually, in the header of the report I will have a message stating " report between 01/01/2007 and 28/05/2007. And these days must be changed upon the dates in subformB.

Thank you for help.
Abolos

[puppydogbuddy]

Salut,

Suppose I have frmA and subformB inside frmA. I have a button opens a report rptA based on subformB. In this report I have txtA and textB. In subformB I have date

01/01/2007
12/02/2007
03/03/2007
28/05/2007

I want to have the txtA and txtB in rptA the MIN and MAX dates in the list above. This means that txtA in rptA must contain 01/01/2007 and txtB in rptA must contain 20/05/20007.

Actually, in the header of the report I will have a message stating " report between 01/01/2007 and 28/05/2007. And these days must be changed upon the dates in subformB.

Thank you for help.
Abolos

Control Source of txtA = Min(Forms!frmA!subformB.Form!YourDateField.Value)
Control Source of txtB = Max(Forms!frmA!subformB.Form!YourDateField.Value)

report header>>>between txtA.Value And txtB.Value

[abolos]

Thanks for reply. But it gives me "Enter Parameter Value". I solved it by not adding the subformB.form to the syntox. It is now taking the value directly from the txtA and txtB in the form and not in the subfomB.

Thanks a lot.