I want to use a form to add record to table 'Instructor'. controls on the 
form are:

Name (text)
EN    (integer, primary key in Instructor table)
FT_Fall (single)
PT_Fall (single)
FT_Spring (single)
PT_Spring (single)
Adjust (single)

When user click 'Add It' button, additional field not shown on the form:
SetupID = 1
WS = 0
Manually_Added = YES

1 record (all above 10 fields) will be added to Instructor table without 
violating primary key.

Should I use Instructor table as unline source for the form? If so, records 
always shows.

Also, what should the 'Add It' button code be?

Thanks. 

Song,

You could just make a form linked to the table Instructor. You don't have to 
make a button Add it because the record will be saved automatically when 
exiting the last field. If you don't want to see all the records you could 
set the form to Data entry mode. If you do want to see the previous records 
you don't have to change any mode.

hth
-- 
Maurice Ausum


"Song Su" wrote:

> I want to use a form to add record to table 'Instructor'. controls on the 
> form are:
> 
> Name (text)
> EN    (integer, primary key in Instructor table)
> FT_Fall (single)
> PT_Fall (single)
> FT_Spring (single)
> PT_Spring (single)
> Adjust (single)
> 
> When user click 'Add It' button, additional field not shown on the form:
> SetupID = 1
> WS = 0
> Manually_Added = YES
> 
> 1 record (all above 10 fields) will be added to Instructor table without 
> violating primary key.
> 
> Should I use Instructor table as unline source for the form? If so, records 
> always shows.
> 
> Also, what should the 'Add It' button code be?
> 
> Thanks. 
> 
> 
>