Combo box selection updated to tables

[Fie]

Hey,

When i enter new records into my database via the forms that i have set
up it seems to save only 1 record, and as soon as you enter a new
record it over writes the previous 1. I think it may have something to
do with the comb boxes that i have

I have 2 combo box's

(1) [Combo24] which has 4 columns in it

1. School
2. No Pupils
3. School code
4. Cost Centre

(2) [Comb14] which has 1 column in it

1. No days


i have tried adding the save button to my forms but it does not work...
any suggestions?

 

[John Vinson]

Hey,

When i enter new records into my database via the forms that i have set
up it seems to save only 1 record, and as soon as you enter a new
record it over writes the previous 1. I think it may have something to
do with the comb boxes that i have

I have 2 combo box's

(1) [Combo24] which has 4 columns in it

1. School
2. No Pupils
3. School code
4. Cost Centre

(2) [Comb14] which has 1 column in it

1. No days


i have tried adding the save button to my forms but it does not work...
any suggestions?

What is the Form's RecordSource property? All a combo box does is take
data from one table (your School table I presume) and store one field
of it into another table, the Control Source field of the combo box in
the Form's Recordsource query.

I don't think it's *just* the combo boxes. It's something in the way
you have the Form set up. Normally, you don't need a save button, or
need to do anything other than move to a new record (using the *> icon
in the navigation buttons at the bottom of the form, or just tabbing
through the fields to the last one).

John W. Vinson[MVP]