one form for multiple tables

[theuman]

I have the following form:

The far right drop down menu has thee values, 1,2, and 3

I want it so that if you select 1 it instert the data into table 1

If you select 2 it inserts the data into table 2 etc



Also how can I replace member number with the acctual member number if its booked for that time?

Thanks

 

[dcobau]

create 3 append queries, one for each table then use Select Case to append the data according to the number you choose.

Dave