How do i create a form so that i can populate two different table.

[Guest]

I am desining a form that needs to populate two tables to make it easer for
the person to fill in on the computer I can do it by creating two forms which
is time consuming please help

 

[John Nurick]

Hi Rosec,

There are various ways of doing this but which is best depends on how
and whether the two tables are related.

If there is a one-to-many relationship between them, it is usually
simplest to create a form bound to the "one" table, and on it put a
subform bound to the "many" table. There are several examples of this in
the Northwind sample database.

If they are unrelated, it's probably best to use two separate forms -
but there is nothign to stop you using an unbound main form with two
subforms on it, one bound to each table.

It's also possible to use one unbound form and write VBA code to manage
storing the data in the tables and retrieving it from them. This needs
advanced knowledge of Access and VBA, and is seldom really necessary.