numbers instead of words

[hrov]

At the minute i have a form that works perfectly well. However at the minute the comboboxes that I have are looking up data from tables, i then assign a time to a customer through this form (in a seperate combobox).

Say customer surname is named "combobox1".

Now i insert a textbox into the form with control source being "[combobox1]".

When i go to form view this textbox is displaying a number. This number represents the row number that the customer belongs to in the original customer table. E.g. a 1 is displayed instead of the name "smith"

I dont want to touch "combox1" as everything is currently working well. But how can i convert this number into the correct name.


As you can proberbly tell im a novice so please explain slowly . Thanks for any answers and i hope i have explained myself clearly

 

[Alc]

Is it possible that the text box is displaying an Auto record number relating to the combo box value? If so, this could be the cause.

Look at the properties for the combo box and see if the data set behind it (a query?) contains both the surname and this record number. The record number may not be visible in the box - perhaps the column width is set to zero? - but you should be able to see it if you click on the three dots to the right of the row source to view the whole query.

If this is the case, you may want to specify that the text box source takes the second column of the combo box as its value, as opposed to just naming the combo box itself
e.g. ComboBox.Column(1) instead of ComboBox

Hope that makes sense.