Unbound field updating all records

  • Thread starter Thread starter JCT
  • Start date Start date
J

JCT

I have a bound continuous subform on which there is an
unbound combo box that updates one of the bound controls
after update. When I change the selection in the combo
box it changes the value in all of the records on the
subform.

Any ideas how to correct this?
 
I have a bound continuous subform on which there is an
unbound combo box that updates one of the bound controls
after update. When I change the selection in the combo
box it changes the value in all of the records on the
subform.

Any ideas how to correct this?
Click to expand...

Well, it's not that easy. On a Continuous form it *looks* like there's
a different control on each row but there really is only one of each
control, displayed multiple times. So if you put an unbound combo box,
you have only one combo box displayed repeatedly; if you change the
combo's properties all of the displays change.

To see a different value in each record you must use a bound control.
What's the purpose of this combo? There's some tricks you can do with
superimposed textboxes or the like.
 
Thanks John - what I did was set the value of the fields
to null on the "on current" event of the subform. Not
ideal, because of course it goes blank as soon as you
enter a value into the field, but it works. Would be
interested in your superimposed text box idea.

The two unbound fields are 'semester' and 'year' which
after update are concatenated into the bound field 'term',
e.g. Fall 2004.
 
Thanks John - what I did was set the value of the fields
to null on the "on current" event of the subform. Not
ideal, because of course it goes blank as soon as you
enter a value into the field, but it works. Would be
interested in your superimposed text box idea.
Click to expand...

The trick works if the table contains a field (or fields which can be
used in a calculation, or linked to a table which does contain the
field) that isn't part of the combo's rowsource when you use
conditional combo box code. Basically, you put a Textbox bound to the
field (or to an expression or a DLookUp, as needed) superimposed on
the text portion of the combo. When the combo is not dropped down you
see the textbox; when it is, you see the values from the combo.
 
Back
Top