Well fianlly managed to get my head round the Calendar problem slightly, however it's now diabled my date query...?????
have a form that searches through date entries and SalesRep names via a query using combo box for SalesRep and the txt boxes for Dates (now being entered via calendar)
query =
SELECT tblWorkRequests.WorkReqID, tblWorkRequests.[DID#], tblWorkRequests.RepName, tblWorkRequests.DateRequested, tblWorkRequests.Client, tblWorkRequests.ContactName, tblWorkRequests.[Tel Std], tblWorkRequests.Telephone, tblWorkRequests.[Post Code]
FROM tblWorkRequests
WHERE (((tblWorkRequests.RepName)=[Forms]![frmWorkSearch]![Combo6])) OR (((tblWorkRequests.DateRequested) Between [forms]![frmWorkSearch]![Command9] And [forms]![frmWorkSearch]![Command10]));
worked fine before added the calendar now it's not
will only return data if I select from Sales Rep and leave dates blank, and if I want to search by date it returns no fields at all, anyone come across this themselves or have an idea why this occurs?
zym
have a form that searches through date entries and SalesRep names via a query using combo box for SalesRep and the txt boxes for Dates (now being entered via calendar)
query =
SELECT tblWorkRequests.WorkReqID, tblWorkRequests.[DID#], tblWorkRequests.RepName, tblWorkRequests.DateRequested, tblWorkRequests.Client, tblWorkRequests.ContactName, tblWorkRequests.[Tel Std], tblWorkRequests.Telephone, tblWorkRequests.[Post Code]
FROM tblWorkRequests
WHERE (((tblWorkRequests.RepName)=[Forms]![frmWorkSearch]![Combo6])) OR (((tblWorkRequests.DateRequested) Between [forms]![frmWorkSearch]![Command9] And [forms]![frmWorkSearch]![Command10]));
worked fine before added the calendar now it's not
will only return data if I select from Sales Rep and leave dates blank, and if I want to search by date it returns no fields at all, anyone come across this themselves or have an idea why this occurs?
zym
