simple query with parameters values coming from a simple a form
Hi,
(MS ACCESS 2003)
I'm trying to make a simple query with parameters values coming from a simple a form.
The issue is that the values that the query gets from the form are displayed as Jiberish.
I've narrowed down the query to simply showing a text box value in the form that supposed to be a date filter for the query: [forms]![ShowResults]![SelDate] - it still shows Jibreish !
However, when I either display this form from a vba code using "msgbox [forms]![showresults]![seldate]" it works fine, also when from the query I convert it to date by cdate ([forms]![showresults]![seldate]) it works fine.
I can't leave it to convert it to date in the query from performance reasons, since the actual query is quite complex.
Any ideas how to solve this?
Thanks!
Re: simple query with parameters values coming from a simple a form
What do you mean by "jibreish" - can you provide an example?