May I ask your help with this one please?
My Form0 has a Field called DueDate in Short Date Format (I’m in the UK).
When I click DueDate, I want to open Form1 filtered to DueDate dates.
But I get mixed results. Either the records returned have month and day are reversed or I get no records or it works perfectly!
Any pointers would be appreciated – thank you.
Here’s the VBA that the wizard wrote
Private Sub DueDate_Click()
On Error GoTo Err_DueDate_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Form1"
stLinkCriteria = "[DueDate]=" & "#" & Me![DueDate] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_DueDate_Click:
Exit Sub
Err_DueDate_Click:
MsgBox Err.Description
Resume Exit_DueDate_Click
End Sub
My Form0 has a Field called DueDate in Short Date Format (I’m in the UK).
When I click DueDate, I want to open Form1 filtered to DueDate dates.
But I get mixed results. Either the records returned have month and day are reversed or I get no records or it works perfectly!
Any pointers would be appreciated – thank you.
Here’s the VBA that the wizard wrote
Private Sub DueDate_Click()
On Error GoTo Err_DueDate_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "Form1"
stLinkCriteria = "[DueDate]=" & "#" & Me![DueDate] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_DueDate_Click:
Exit Sub
Err_DueDate_Click:
MsgBox Err.Description
Resume Exit_DueDate_Click
End Sub