Copying a table to a subform

[jshangkuan]

Say for example I have a table1 with field F1, F2, F3
and a table2 with F1,F4,F5,F6 and table 1 and table 2 are related by F1

I have a separate table called tableHistory that contains information
generated by a query and holds information F1,F3,F5

What VBA code will let me copy from tableHistory to my subform?

Thanks for your help.

 

[Douglas J. Steele]

You don't copy from a table to a form. You make a query based on the table
the recordsource for the form.

 

[jshangkuan]

Can you please provide a simple example?

Thanks

You don't copy from a table to a form. You make a query based on the table
the recordsource for the form.