using form to add new record

S

Song Su

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top