Full Version: Using Form
UtterAccess Discussion Forums > Microsoft® Access > Access Queries
jtwork
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]
Oused 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.
strive4peace
since values in TEXTboxes are, well, text... try wrapping the control reference in a date conversion function
ateValue([forms]![frm_report]![from])
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.