VBA Type Mismatch for link criteria

[jk12]

Hi all

Sorry if this has been answered elsewhere but I can't find the answer anywhere.

I have the code below to open a pop-up form from within a form but whenever the code runs I get Run-time Error 13, Type Mismatch.

Both the EnquiryCatergory and TenderRef fields are text fields as are the Descritpion and Tender fields so why would I get a ype Mismatch. Also when I debug the error and hover over each element I get the correct info shown i.e. Me![Description] = "Paving" and Me![Tender] = "11N216".

Code running is:
stLinkCriteria = "[EnquiryCategory]=" & "'" & Me![Description] & "'" And "[TenderRef]=" & "'" & Me![Tender] & "'"

Any help is appriciated.

 

[pbaldy]

You've got a quotes problem. Try

stLinkCriteria = "[EnquiryCategory]=" & "'" & Me![Description] & "' And [TenderRef]=" & "'" & Me![Tender] & "'"

I personally would avoid the extra concatenation:

stLinkCriteria = "[EnquiryCategory]= '" & Me![Description] & "' And [TenderRef]= '" & Me![Tender] & "'"

 

[jk12]

Perfect. I suspected it was something simple but was more than my brain could handle, especially after trawling through the site and internet for the last hour

 

[pbaldy]

Happy to help.