Update Rowsource Records in unbound combos

[Bill]

If I have an unbound combo box with a Rowsource
that includes an "autonumberd" ID field, AND, I want
to update one of the other fields in current row, how
do I go about doing that?

Say my Rowsource is comprised of a record:

MyID, MySpecialValue, MyTextField

and, I want to update MySpecialValue.

Bill

 

[fredg]

If I have an unbound combo box with a Rowsource
that includes an "autonumberd" ID field, AND, I want
to update one of the other fields in current row, how
do I go about doing that?

Say my Rowsource is comprised of a record:

MyID, MySpecialValue, MyTextField

and, I want to update MySpecialValue.

Bill

By Update do you mean to change the values in each record's
[MySpecialValue] field?

You'll need to run an Update query on the table that contains that
field.

If you mean something else, please post back with more information.

 

[Bill]

By Update do you mean to change the values in each record's
[MySpecialValue] field?
No, just the MySpecialValue field in the currently selected row.
Bill

If I have an unbound combo box with a Rowsource
that includes an "autonumberd" ID field, AND, I want
to update one of the other fields in current row, how
do I go about doing that?

Say my Rowsource is comprised of a record:

MyID, MySpecialValue, MyTextField

and, I want to update MySpecialValue.

Bill

By Update do you mean to change the values in each record's
[MySpecialValue] field?

You'll need to run an Update query on the table that contains that
field.

If you mean something else, please post back with more information.

 

[Bill]

An update query did the trick.
Thanks,
Bill

By Update do you mean to change the values in each record's
[MySpecialValue] field?
No, just the MySpecialValue field in the currently selected row.
Bill

If I have an unbound combo box with a Rowsource
that includes an "autonumberd" ID field, AND, I want
to update one of the other fields in current row, how
do I go about doing that?

Say my Rowsource is comprised of a record:

MyID, MySpecialValue, MyTextField

and, I want to update MySpecialValue.

Bill

By Update do you mean to change the values in each record's
[MySpecialValue] field?

You'll need to run an Update query on the table that contains that
field.

If you mean something else, please post back with more information.