[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

Searching Record problem

I try to do a search by date, but It can found the record, am I did something wrong, I wrote as this :

SearchString = SearchField & " = " & txtFindExpr

frmMailer.datMailer.Recordset.FindFirst SearchString

Note : the searchfield is a date type.

Thanks u in advance.
0
kycheang
Asked:
kycheang
1 Solution
 
jetforceCommented:
Try this
SearchString = SearchField & " = #" & txtFindExpr & "#"

Hope this helps
Jetforce
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now