Using value from a form field.

[VegaLA]

Hi all,
I have a form that has two fields, date from and Date to,
the user enters the dates in these fields then hits a button to display the results from a query.

The code for the criteria of the query is as follows

Between [frmName]![txtdate].[value] And [frmName]![txtdateTo].[value]

but every time I hit the button to run the query the 'Enter parameter value' input box appears. Have I coded the query wrong ? I have tried

Between [frmReports]![txtdate] And [frmReports]![txtdateTo]

as well but no success, can someone please tell me where I am going wrong.

I am using Access 2002 on Win 2000

Thanks,
Mitch....

 

[pbaldy]

Forms!FormName.ControlName

 

[VegaLA]

Thats it !!

Thank you very much.

Mitch.......