Welcome to the skill header Forums. You can ask questions, get help, or help other members out. Join our Forum for free.

Date Filter not fun...
 
Notifications
Clear all

Date Filter not functioning properly

2 Posts
2 Users
0 Reactions
37 Views
Posts: 18
Topic starter
(@arseyguy)
Eminent Member
Joined: 8 months ago

Hi, Please help me with the Date filter. It filters correctly in some dates but sometimes it doesn't and sometimes it shows empty result. Attached is the screenshot showing 0 records and below are the code.

Dim strSearch As String
strSearch = "[DateOfTransaction] Between #" & Me.txtDtFrom & "# and #" & Me.txtDtTo & "#"
Me.Form.Filter = strSearch
Me.Form.FilterOn = True

1 Reply
FStetson
Posts: 59
(@fstetson)
Trusted Member
Joined: 8 months ago

If you could post the entire vba code for your “Search Between” button. It might provide more insight

Reply
Share: