saving records in form

Gary,

You have made a fundamental database design error.

For correct operation, each of the "car.." lines should be a separate
*record* in the table that the form is bound to.

Therefore, I suggest you follow the concept I mentioned in my earlier post:

It sounds like you have comboboxes in each "row" bound to the same
fields, which achieves no purpose.

In design view of the form, first of all remove all of the comboboxes
from the car2 - car5 lines, i.e. so you are left with only one "set" of
comboboxes for name, shirt, pants, etc.

Then, find the Property of the form called Default View, and change it
from 'Single Form' to 'Continuous Forms'. Adjust the height of the
Detail section of the form so that it is only a little higher than the
height of the combobox.

Now open the form in form view. If I have understood you correctly, you
should now be able to enter as many names as you want.

--
Steve Schapel, Microsoft Access MVP

gary wrote:
thank you steve, okay here goes.....
my form is populated with combo boxes(in caps) the lower case words are
labels

car1- NAME SHIRT PANTS SHOES BELT HAT
car2- NAME SHIRT PANTS SHOES BELT HAT
car3- NAME SHIRT PANTS SHOES BELT HAT
car4- NAME SHIRT PANTS SHOES BELT HAT
car5- NAME SHIRT PANTS SHOES BELT HAT

all of the combo boxes on the form are bound to a single table...the table
looks something like this...

COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6
frank blue slacks shiney leather
derby
steve white jeans dull swede
cowboy
mike red dirty deck long
helmet
tony green clean slipper short
beret
sam black torn heel buckle
cap

i open my form and start with car1...i select mike under name, i select blue
for mikes shirt, i select dirty for mikes pants, and slipper for mikes
shoes........
then i go to car2...i select sam under name, i select red for sams shirt, i
select torn for sams pants, and dull for sams shoes.
-problem--i select mike for car1, and blue for mikes shirt.....
i get to car2 and select sam..car1 instantly changes from
mike to sam
i select red for sams shirt, and mikes shirt instantly
changes from blue
to red. i want car1 to be mike with blue shirt
and car2 to be sam with red shirt .........

thank you steve...in my form each "car" line is a seperate *record* in the
table that is bound to my form...
i have the combo boxes in each "row" (from top to bottom) bound to the same
fields...
your remedy is to remove all combo boxes except for one "set" or "line".
problem--i need all "rows" (from top to bottom) on my form. i need each
combo box in each "row" to update with a different value from the same field
or "column"
in my table that is bound to my form.............
thank you again steve..



--
gary


"Steve Schapel" wrote:

Gary,

You have made a fundamental database design error.

For correct operation, each of the "car.." lines should be a separate
*record* in the table that the form is bound to.

Therefore, I suggest you follow the concept I mentioned in my earlier post:

It sounds like you have comboboxes in each "row" bound to the same
fields, which achieves no purpose.

In design view of the form, first of all remove all of the comboboxes
from the car2 - car5 lines, i.e. so you are left with only one "set" of
comboboxes for name, shirt, pants, etc.

Then, find the Property of the form called Default View, and change it
from 'Single Form' to 'Continuous Forms'. Adjust the height of the
Detail section of the form so that it is only a little higher than the
height of the combobox.

Now open the form in form view. If I have understood you correctly, you
should now be able to enter as many names as you want.

--
Steve Schapel, Microsoft Access MVP

gary wrote:
thank you steve, okay here goes.....
my form is populated with combo boxes(in caps) the lower case words are
labels

car1- NAME SHIRT PANTS SHOES BELT HAT
car2- NAME SHIRT PANTS SHOES BELT HAT
car3- NAME SHIRT PANTS SHOES BELT HAT
car4- NAME SHIRT PANTS SHOES BELT HAT
car5- NAME SHIRT PANTS SHOES BELT HAT

all of the combo boxes on the form are bound to a single table...the table
looks something like this...

COLUMN1 COLUMN2 COLUMN3 COLUMN4 COLUMN5 COLUMN6
frank blue slacks shiney leather
derby
steve white jeans dull swede
cowboy
mike red dirty deck long
helmet
tony green clean slipper short
beret
sam black torn heel buckle
cap

i open my form and start with car1...i select mike under name, i select blue
for mikes shirt, i select dirty for mikes pants, and slipper for mikes
shoes........
then i go to car2...i select sam under name, i select red for sams shirt, i
select torn for sams pants, and dull for sams shoes.
-problem--i select mike for car1, and blue for mikes shirt.....
i get to car2 and select sam..car1 instantly changes from
mike to sam
i select red for sams shirt, and mikes shirt instantly
changes from blue
to red. i want car1 to be mike with blue shirt
and car2 to be sam with red shirt .........

Gary,

Can I just ask... did you adjust the Default View property of the form,
so it is Continuous rather than Single?

--
Steve Schapel, Microsoft Access MVP

gary wrote:
thank you steve...in my form each "car" line is a seperate *record* in the
table that is bound to my form...
i have the combo boxes in each "row" (from top to bottom) bound to the same
fields...
your remedy is to remove all combo boxes except for one "set" or "line".
problem--i need all "rows" (from top to bottom) on my form. i need each
combo box in each "row" to update with a different value from the same field
or "column"
in my table that is bound to my form.............
thank you again steve..