Can you use a sql statement that includes a join for a recordsource in an adodc control? I am having trouble getting a data grid to 'behave' trying to set it's recordsource properties in code. Here is my code:



code:--------------------------------------------------------------------------------

sql = "SELECT * FROM PartData pd INNER JOIN RaceData rd ON pd.RaceID = rd.RaceID "
sql = sql & "WHERE rd.EventID = " & lEventID & " ORDER BY pd.LastName, pd.FirstName"
Set rs = New Recordset
rs.Open sql, conn, adOpenStatic, adLockOptimistic
Set dgPartData.DataSource = rs
dgPartData.Refresh

--------------------------------------------------------------------------------


Could I use this in an adodc as the recordsource?

Thanks!

Yes you can.

That is you can do it in code .

First you have to set the propertys of the controle,
odbc connection/db-string ect.

First set the recordsource to 8 (unknown)

in code build your sql string, then set the recordsource property to text and set the text to your sql string and refrsh it