form button to populate table A or B

J

Jon S.

Hello all,

I am wondering how to out a button or checkbox on a form that when clicked
will dictate what table the user is populating when the complete the form.

Basically, I have two tables that will be maintained via one form and cannot
think of another way (short of having two different forms) to accomplish
this.

Any suggestions? It might be rally simple, as I am new to Access.

Thanks-
 
R

ruralguy via AccessMonster.com

What type of data do the tables contain that requires two tables? Are you
using a bound form?
 
P

Piet Linden

Hello all,

I am wondering how to out a button or checkbox on a form that when clicked
will dictate what table the user is populating when the complete the form..

Basically, I have two tables that will be maintained via one form and cannot
think of another way (short of having two different forms) to accomplish
this.

Any suggestions?  It might be rally simple, as I am new to Access.

Thanks-
Click to expand...

Why not just include a flag field in your table design and write all
the records to the same table?
 
L

Linq Adams via AccessMonster.com

I assume that in order the do this the fields are the same for both tables,
and if this is correct, Piet's suggestion is the way to go.
 
Top