DataGrid displaying RecordSet Child?

[Skrmetti]

I am trying to get a DataGrid to display the Child portion of a RecordSet (The Parent information is displayed in labelled textboxes above; they are linked through a common field, which are also linked in the Access database).

The problem is, whenever I test the application the DataGrid either displays the data from the Parent fields of the RecordSet or remains blank. I don't think the problem is with the SQL:

SHAPE { select ComponentNumber,FireZone, PIDLocation,PIDNumber,SystemNumber,Comments from Component Order by Component Number } AS ParentCMD APPEND({ selectDeviceNumber, ComponentNumber, Location, Coments from Device Order by DeviceNumber } AS ChildCMD RELATE ComponentNumber TO ComponentNumber ) AS ChildCMD

The Code for the DataGrid is:

Private Sub Form_Load()
Set grdDataGrid.DataSource = datPrimaryRS.Recordset("ChildCMD").UnderlyingValue
End Sub

Any advice?

TIA,
Jonathan

------------------
"Black?"
"For over thirty years."

[Skrmetti]

Never mind. I left for lunch, and when I came back that part of the app was working fine. Sorry for the clutter.

Thanks,
Jonathan