append record from form

  • Thread starter Thread starter Guest
  • Start date Start date
Jenny,

If the form is based on the table, in other words if you use the table
as the recordsource of your form, the data will be saved to the table
when you close the form, or move to a new record.
 
Stev
thanks for your reply. My form is based on my table, but when i make a selection out of my combo box i want to be able to save several selections from my combo box, it just keeps updating it. Im new and i just dont understand what needs to be done. I dont want to have redunit data
thanks Je

----- Steve Schapel wrote: ----

Jenny

If the form is based on the table, in other words if you use the table
as the recordsource of your form, the data will be saved to the table
when you close the form, or move to a new record
 
Jen,

What is the combobox you are referring to? Maybe it is best if we start
from scratch here... you will need to give full details of the fields in
your table, what you have on the form, what you want to happen (with
examples), and what's not working as expected.
 
Well I have a table with Staff ID is my key field= name, address, phone # date of trainingand training. There is several different kinds of training that is held on different dates. I made a combo box on my form and listed the trainings. One person will have several different training on several different dates. I need to keep a record of all training and dates that each person had the training
Can I send you my database and you fix it for me? I also tried an append query but that just keeps putting all the records in again and again
Thanks for any help you might be able to give me.

----- Steve Schapel wrote: -----

Jen,

What is the combobox you are referring to? Maybe it is best if we start
from scratch here... you will need to give full details of the fields in
your table, what you have on the form, what you want to happen (with
examples), and what's not working as expected.
 
Jenny,

The basic concept here, is that there can be more than one training
record for each staff member. This is known as a one-to-many
relationship between staff and training. This dictates that training
must be stored in another table than staff. You need two tables, like
this...

Table: Staff
Staff ID
StaffName
Address
PhonNumber

Table: Training
TrainingID
Staff ID
DateOfTraining
Training

Then, you would make a form based on the Training table, and put it on
the Staff form as a subform, with the Staff ID feild from both being the
linking field.

I suggest you download, and readd, the document available from
http://support.microsoft.com/?id=234208
and view the webcast from
http://support.microsoft.com/default.aspx?scid=/servicedesks/webcasts/wc060600/wcblurb060600.asp

You wil also need to read up on forms/subform design.
 
Back
Top