saving records in form

[Steve Schapel]

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.

 

[Guest]

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

 

[Steve Schapel]

Gary,

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