Linking Parent/Child forms where both forms' Recordset properties are bound to ADO Recordset

C

Craig Buchanan

I have a parent/child form combination. Both forms have their respective
Recordset properties set to an ADODB Recordset. I have the Link Child
Fields and Link Master Fields set to the appropriate values. When I scroll
the main form, however, the child form doesn't change. If I would have
simply set each form's record source property, this would work.

Obviously, I'm missing something. Can someone clue me in?

Thanks,

Craig Buchanan

<CODE>
Private Sub Form_Open(Cancel As Integer)

Dim RS As New ADODB.Recordset
With RS
.ActiveConnection = Application.CurrentProject.Connection
.Source = "Folder"
.CursorType = adOpenKeyset
.CursorLocation = adUseClient
.LockType = adLockOptimistic
.Open
End With

Set Me.Recordset = RS
Set RS = Nothing

End Sub
</CODE>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Assign recordset - subform 1
ADO recordset can not be updated 0
why a form bound to ADO recordset from DB2 is readonly 4
Form bound to Recordset issue 4
ADO Form bind 4
recordset values displaying only *one* value on form 7
Cannot update a disconnected (and then re-connected) ADO recordset bound to Access 2003 form 5
adOpenStatic Recordset still changing my table 5

Top