Having a hard time 2 controll source in one form.

[LyTseu]

Hello All,

I'm having a hard time setting up a form using two control source.

Let me explain to you my form first.

The form acquires data and date and comment in table A
so we have Category1, Date completed and Comment as main column in table A.

I have a table B that I want to link to the same Form...
Column in Table B are:
Part Used
Misc. 1
Misc. 2

The reason why I'd like to have two table in one form, is that when the user access the form, he will fill the complete form. So I can export Table B and send it by email.

So how do I insert two record source in the main form?
I've tried in control source
= SELECT tableA.*, TableB.*

But didnt work =(

Thank you for taking your time to read this!

[colintis]

With more than one table as record source, you can try to create a query that only extract the columns you need from both table A & B, and use this query as record source.

[LyTseu]

Hello Colintis,

But will the new information stored using table A & B data, will still be in another table? (different than the main table used for the form?) which will alow me to send that table seperatly. Or is there a simpler way.

Thank you,
Ly.

[colintis]

Query simply pulls data directly from the table and put them up the screen, it doesn't store anything as a new table, which is very useful to get parts from many tables and generate the result into one screen. And this is the most simple way, this is also the only solution for putting multiple tables as record source in the form.

If you don't understand the coding very well, the design mode in the query will be very helpful to you.

[LyTseu]

Thank you for your help!