form button to populate table A or B

  • Thread starter Thread starter Jon S.
  • Start date Start date
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-
 
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?
 
Back
Top