linking unbound subform

[faz88]

Hi,
Am not sure if this is possible...Can you link a unbound subform to a unbound main form through vba? if so how would you do it....

[Trevor]

No you can't Link, but you can use an insert into table query to perform the same operation(s) is this what your looking to do, if you would rather link them then you need a common field between the subform and main form then you need to set the recordsource on both forms, and on the subform you set the common field (linked field) betweenthe 2 forms.