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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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.
>

Can you please provide a simple example?

Thanks
On Jan 24, 4:50 pm, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_canada.com> wrote:
> You don't copy from a table to a form. You make a query based on the table
> the recordsource for the form.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no private e-mails, please)
>
> <jshangk...@gmail.com> wrote in messagenews:(E-Mail Removed)...
>
>
>
> > 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.- Hide quoted text -- Show quoted text -