how to get date in criteria

[wasim_sono]

Dear All

I have a criteria form which accept values in different text boxes through combo boxes.One of these is a text box for accepting date.

I want to use this inputs in my query as



like forms.criteriaforms.fdate



if there is no inputs then by default fdate=* to display all dates.

the above code is not working.

can any one help me?


Regards


Wasim

[OBP]

Is that the Crieria that you are putting in the Criteria Row of the query?
If so, you could try
like "*" & forms.criteriaforms.fdate & "*"