Made the bound field of a combo the item ID but want the text equivalent in the table

[sleake]

I goofed and forgot to change the bound field of the combo to "2." So now my table has the ID values instead of the text. What kind of query can I construct to update the ID values to their text equivalent?

[orange]

You haven't shown us anything. But if you have created records, you could delete them, then change the bound column in the combo and try again. Hopefully all of this in in a test environment.