Copying a table to a subform

  • Thread starter Thread starter jshangkuan
  • Start date Start date
J

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.
 
You don't copy from a table to a form. You make a query based on the table
the recordsource for the form.
 
Back
Top