Combo box in subform repeating

[Guest]

I have a subform displaying the multiple child records for the parent record
in the form. There is a combo box displaying values from a third (lookup)
table. When a value is chosen from the combo box in any of the child
records, all the values for that same field change in every child record.

How do I build this subform so the user can choose a distinct value for each
of the child records? What am I doing wrong?

TIA

Kevin D

 

[strive4peace]

Hi Kevin,

sounds like you need to make your control bound... fill out
the ControlSource in the property sheet -- it needs to be
one of the fields in your table if you want to be able to
change it.

If you just want to display something different on every
row, put the calculation in the underlying recordset



Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*