I have a form with 2 fields.
One is for a date and the other is for combo box. I have a command button that should open another form with the data from the Original form. Here is my code behind the button.
Dim stDocName As String
Dim stLinkCriteria As String
Dim stLinkCriteria1 As String
stDocName = "frmChargeBackBalanceLookup"
stLinkCriteria = "[CardType]=" & "'" & Me![CardType] & "'"
stLinkCriteria1 = "[rptDate]=" & "#" & Me![DateRpt] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria And stLinkCriteria1
With this code I get an Access popup that says Type Mismatch. It only has the OK button so I can not see where I am messing up.
Thanks
Krash
One is for a date and the other is for combo box. I have a command button that should open another form with the data from the Original form. Here is my code behind the button.
Dim stDocName As String
Dim stLinkCriteria As String
Dim stLinkCriteria1 As String
stDocName = "frmChargeBackBalanceLookup"
stLinkCriteria = "[CardType]=" & "'" & Me![CardType] & "'"
stLinkCriteria1 = "[rptDate]=" & "#" & Me![DateRpt] & "#"
DoCmd.OpenForm stDocName, , , stLinkCriteria And stLinkCriteria1
With this code I get an Access popup that says Type Mismatch. It only has the OK button so I can not see where I am messing up.
Thanks
Krash