linked combo boxes in data sheet subform

S

Shannon

I have 2 linked combo boxes in a data sheet subform. The problem is that
while the linked displays the correct things when I click it open, when I
select one, the whole column fills with that 1 selection. When I click into
another box, it all deletes. My guess is that I need some code to separate
each record. How do I do so?
 
O

Ofer

When the fields (the combo box in that case) are unbound and you make a
selection the all column will be filled with that same value, you need to
bound the combo box to a field in the table that the sub form is bounded to.
 
Top