Here is my situation....
Our IT department upgraded us to Windows XP and Access 2000 (9.0.3821 SR-1) and this has caused problems opening a filtered form.
The error I'm getting is "This is an invalid use of the . (dot) or ! operator or invalid parentheses". Here is the code the opens the form, if anyone knows why I'm getting this message your assistance would be greatly appreciated.
-----------------------------------------------------------
On Error GoTo Err_Command50_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmResourcePhone"
stLinkCriteria = "[Date]= " & "#" & Me![txtDate] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command50_Click:
Exit Sub
Err_Command50_Click:
MsgBox Err.Description
Resume Exit_Command50_Click
Our IT department upgraded us to Windows XP and Access 2000 (9.0.3821 SR-1) and this has caused problems opening a filtered form.
The error I'm getting is "This is an invalid use of the . (dot) or ! operator or invalid parentheses". Here is the code the opens the form, if anyone knows why I'm getting this message your assistance would be greatly appreciated.
-----------------------------------------------------------
On Error GoTo Err_Command50_Click
Dim stDocName As String
Dim stLinkCriteria As String
stDocName = "frmResourcePhone"
stLinkCriteria = "[Date]= " & "#" & Me![txtDate] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria
Exit_Command50_Click:
Exit Sub
Err_Command50_Click:
MsgBox Err.Description
Resume Exit_Command50_Click