One form, two tables...

Is there anyway to have a form that once data is entered, writes the date out
to two different tables. i.e. one section of the form will dump data into
table A and the other section will dump data into Table B.

Thanks

Use a query as record source for the form that has both tables.

"Andy" wrote:

Is there anyway to have a form that once data is entered, writes the date out
to two different tables. i.e. one section of the form will dump data into
table A and the other section will dump data into Table B.

Thanks

Sure. Just include both tables in the query upon which your form is based.
Then pull the various fields from each table onto your form.

We'd need to know a bit more about your data structure and what you are
trying to accomplish to give you a more detailed answer.

If you have a one-to-many relationship, the answer is a bit more complex,
but still very easy to do.


--
Rick B



"Andy" wrote in message
...
Is there anyway to have a form that once data is entered, writes the date
out
to two different tables. i.e. one section of the form will dump data into
table A and the other section will dump data into Table B.

Thanks