form/subform ADODB recordset

[rashima]

I have access2010 as front end, sql-server as back-end (no link tables)

i have 2 tables one-to-many relationship in sql server and want to have that data with parent/child relationship on access form.

on main form i display records like this

sRepSQL = "SELECT * from View_Detail "

conMyRepConnection.ConnectionString = MyConnectionString
conMyRepConnection.Open
rsReportList.Open sRepSQL, conMyRepConnection, adOpenStatic, adLockPessimistic
Set Me.Recordset = rsReportList


how to display records on subform ??


Detail_ID is the common child-parent relationship key.

[June7]

Never used SQL and don't work with unbound data forms. So just guessing but after setting the RecordSource of the subform, maybe use code to set the Master/Child link properties of the subform container control?