[RESOLVED] Error in code

[osemollie]

Am trying to search my database using dates. Where am i going wrong? My code is

If chkPurchased.Enabled Then sWhere = sWhere & sKeyWord & "PurchaseDate >= & "#" & dtpPurchaseAfter.Value & "#" AND PurchaseDate <= & "#" & dtpPurchaseAfter.Value & "#"

Thanks.