combo box

[susan]

I have 1 simple table that needs to be joined with working
table. That first table will be a combo box in table 2.
Problem: In Form the combo box repeats itself in each
record, rather than each selection remaining in each
record. Any suggestions?

 

[Ken Snell]

In order to use a combo box in a "continuous forms" view (such as you're
describing for your form) and have the combo box hold different values for
each record, the combo box must be bound to a field in the form's
recordsource. Otherwise, each combo box displays the same result because, in
reality, the multiple combo boxes are just one box...the same box...for all
records.