Need help on criteria form.

[dilara]

Hi,



I have a form that is meant to input criteria for a certain query. The form consist of 2 combo boxes and 2 text box for the Between/And dates. The combo boxes are working fine, however i can't see whats wrong my date criteria as access is not returning any result.

Form Name is frmKLAdHoc
tbx1 is KLStartDate
tbx2 is KLEndDate

then here's the SQL for my query

SELECT tblKLMain.[Date Submitted], tblKLMain.[Client Name], tblKLMain.[Matter Name], tblKLMain.[Client Number], tblKLMain.[Matter Number], tblKLMain.[Form Type], tblKLMain.[Submitted by]
FROM tblKLMain
WHERE (((tblKLMain.[Date Submitted]) Between [Forms]![frmKLAdHoc]![KLStartDate] And [Forms]![frmKLAdHoc]![KLEndDate]) AND ((tblKLMain.[Form Type])=[Forms]![frmKLAdHoc]![cboKLFormType]) AND ((tblKLMain.[Submitted by])=[Forms]![frmKLAdHoc]![cboKLUsername]));

thank you for your help.

[R_Badger]

This is going to sound stupid, but where do you live/ what date format are you using? Also are the fields in the table stored as date/time or as text?

[dilara]

I am from the Philippines. The date format in the tblKLMain is Medium Date while the format of the text box is left blank. Thanks