Subform combo box selection effects all records

[Guest]

Access 2003. Subform has Master-Child link to table underlying main form
(one-to-many). I've changed one of the subform's controls to an unbound
combo box since there will be a limited vocabulary for the field. A "SELECT
DISTINCT ..." query is the row source for the combo box and its control
source is blank. If I'm entering a new record on the subform, and select a
value from the combo box' list, all records in the subform are populated with
that value rahther just the field for the record being added. What have I
done wrong?

 

[Carl Rapson]

Access 2003. Subform has Master-Child link to table underlying main form
(one-to-many). I've changed one of the subform's controls to an unbound
combo box since there will be a limited vocabulary for the field. A
"SELECT
DISTINCT ..." query is the row source for the combo box and its control
source is blank. If I'm entering a new record on the subform, and select
a
value from the combo box' list, all records in the subform are populated
with
that value rahther just the field for the record being added. What have I
done wrong?

Unbound controls aren't very useful in continuous forms (I assume the
subform displays multiple records). In a continuous form, there is really
only one set of controls, even though it looks like there are many. If you
change the value in an unbound control, that value shows on every record.

Carl Rapson

 

[Guest]

So is there no solution? Could I add an unbound combo box that's not tied to
the data table so that it covers the unbound control on the subform then run
an update event when the new combo box loses focus?

 

[Carl Rapson]

What's the purpose in having an unbound control on your subform? If it's
simply to display a value for informational purposes, maybe you could put
the control on the parent form instead and set its value in the Current
event of the subform:

Me.Parent.Form.cboControl = "some value"

Carl Rapson