Not sure why this has happened but this has been working for weeks and now i have a problem.

I have a form which i input a from and to date

[forms]![frm_report]![from]
[forms]![frm_report]![to]

I used these values in my query as expressions so i would know what date the data was for

Date_From: [forms]![frm_report]![from]
etc

Now they are appearing blank. I have tried changing the text box format from short date to blank (text) and this seems to sort the problem but i would like it as short date, it worked beore so not sure why not now.

since values in TEXTboxes are, well, text... try wrapping the control reference in a date conversion function

DateValue([forms]![frm_report]![from])