combobox value written as list number not text string

[action]

I have some code updating a table using recordset I have found that for a combobox value it is grabbing the item's list number instead of the text. Otherwords if the text selected is "writeoff" and writeoff is the 5th value in the orginal table which the combobox refers to then the value "5" is recorded by the recordset. How can I get it so that the text is recorded not the value?

Cheers

 

[action]

thanks

Thanks Pat, found I had a autonumber which had found it's way in.

Also I have been trying to concatenate (is that the right word?) two fields in a recordset, this is what I tried but no go. Is this possiable like this?

rs![Reference] = Me([TXTCurrentloggedon] And " - " And [ComboReasonfortransfer])


Cheers

 

[geralf]

Use & instead of AND. AND is a logical operator.

rs!Reference = Me.TXTCurrentloggedon & " - " & Me.ComboReasonfortransfer

 

[action]

Thanks geralf, easy as!