populate subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to populate a subform with an ADODB recordset? When the
recordsource is set this way, the Access linking feature (master to child)
doesn't work. I presume I will have to pass a key value on opening the main
form. Is that what others have done (or just avoided the situation?)
 
IME, it is impractical, Sam.

If there is anything in the LinkMasterFields and LinkChildFields property of
the subform control, Access reloads the subform each time the main record
changes (or whatever is named in LinkMasterFields.) As a result, assigning a
Recordset to the subform does not work well, as it is quickly replaced.
 
Back
Top