Help with Concatenate function 1

[Dirtbike]

I originally posted on the FORMs page...my bad.

http://www.tek-tips.com/viewthread.cfm?qid=1244545

Some kind person pointed me toward Duane's super-duper Concatenate() code. Thanks.

I'm getting the dreaded data type missmatch in criteria.
Here is my SQL:
SELECT tn_p1.SONumber, Concatenate("SELECT tn FROM tn_p1 WHERE SONumber = " & [SONumber]) as Notes
FROM tn_p1
WHERE (((tn_p1.SONumber)="00100211678"));

I have verified I'm ADO. The debug points to a problem here:

rs.Open pstrSQL, CurrentProject.Connection, _
adOpenKeyset, adLockOptimistic

I tried DAO and also crash on datatype missmatch although it points more directly to the pstrSQL. Thanks for the help.

 

[JerryKlmns]

SELECT tn_p1.SONumber, Concatenate("SELECT tn FROM tn_p1 WHERE SONumber ='" & [SONumber] & "'") as Notes
FROM tn_p1
WHERE SONumber='00100211678';

SONumber looks like of text data type

 

[Dirtbike]

That is CORRECT!...so, I'll try your code and hollor again if it doesn't work.