B
bladelock
I place a comboBox, (which get data from a table) on a form for the user. It
works fine, however, On the form is shows the proper doctors name on the
table it shows the number of the record that was select and not the doctors
name. When I print a report only a number shows up and not the name. When I
go back to the form the name appears instead of the number. How can I make
this work?
The combobox has this:
rowsource type: Table/Query
rowsource: SELECT DOCTORS.Numbers, DOCTORS.NAME FROM DOCTORS;
bound column: 1
works fine, however, On the form is shows the proper doctors name on the
table it shows the number of the record that was select and not the doctors
name. When I print a report only a number shows up and not the name. When I
go back to the form the name appears instead of the number. How can I make
this work?
The combobox has this:
rowsource type: Table/Query
rowsource: SELECT DOCTORS.Numbers, DOCTORS.NAME FROM DOCTORS;
bound column: 1