H
hughess7
Hi all
I am trying to open a popup form based on the 'key' of the main form by
putting these variables into a where condition...
stLinkCriteria = ([Review Date] = Format(dtReview, "\#mm\/dd\/yyyy\#")) And
"([Country Code] = '" & txtCountry & "') AND ([Dealer_Code] = '" & txtDealer
& "') AND ([NE Claim No] = '" & txtClaim & "')"
I get type mismatch error? All are text data types apart from Review Date
which is a date variable.
P.S. For ref I don't want a subform as I want it to appear as a popup to the
user.
Thanks in advance for any help.
Sue
I am trying to open a popup form based on the 'key' of the main form by
putting these variables into a where condition...
stLinkCriteria = ([Review Date] = Format(dtReview, "\#mm\/dd\/yyyy\#")) And
"([Country Code] = '" & txtCountry & "') AND ([Dealer_Code] = '" & txtDealer
& "') AND ([NE Claim No] = '" & txtClaim & "')"
I get type mismatch error? All are text data types apart from Review Date
which is a date variable.
P.S. For ref I don't want a subform as I want it to appear as a popup to the
user.
Thanks in advance for any help.
Sue