form button to populate table A or B

[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-

 

[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-

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