A field shows a numeric value and not the text enterred

D

Dave Boreham

My table is populated from a form. I enter a place name into a combo box.
When I then look at the table the field for this box shows a numeric value
and not the name
 
G

Golfinray

Check the datatype of the field in the table and check the control source of
the form.
 
M

MikeJohnB

Check the Bound Column of the Combo Box, you are populating the table with
the PK field instead of the Text Field column. Try changing the bound column
by adding one to the current value and see what that does for you? (Eg
Current Bound Column = 1 try Bound Column =2)

Hope this answers your question???

Regards

Mike B
 
Top