G
Gntlhnds
One of the fields in my table started out as a text field, then I changed it
to a value list combo box, and then again to a table combo box. The problem
is that now the combo box on the form is showing the ID number instead of the
name. And unless I go and select from the drop down list (which shows the
names correctly) what the combo box is supposed to show, none of my reports
work that are based on that field. The combo box is set up as text, with
column 1 set at 0" and column 2 as 2" and the bound column. I have to set it
up this way because the data that gets imported into the table is text, and
the user has to then select from the combo box which name is best suited for
the data that gets imported. I need to do one of two things, either run an
update query that will look and see what number is showing up in the combo
box, compare that to the table that stores the combo box's row source, and
then select the correct name, or figure out why it is showing the ID instead
of the name. I don't relish going back and manually changing all 600 records
to show what is supposed to be in the combo box.
to a value list combo box, and then again to a table combo box. The problem
is that now the combo box on the form is showing the ID number instead of the
name. And unless I go and select from the drop down list (which shows the
names correctly) what the combo box is supposed to show, none of my reports
work that are based on that field. The combo box is set up as text, with
column 1 set at 0" and column 2 as 2" and the bound column. I have to set it
up this way because the data that gets imported into the table is text, and
the user has to then select from the combo box which name is best suited for
the data that gets imported. I need to do one of two things, either run an
update query that will look and see what number is showing up in the combo
box, compare that to the table that stores the combo box's row source, and
then select the correct name, or figure out why it is showing the ID instead
of the name. I don't relish going back and manually changing all 600 records
to show what is supposed to be in the combo box.