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!