populate subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

smk23 - 19 Jan 2006 13:21 GMT

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?)

Signature

sam

Reply to this Message

Allen Browne - 19 Jan 2006 13:37 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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?)

Reply to this Message