hi Paul,

On 26.01.2010 10:21, PVANS wrote:
I need to keep the bound column as column 3 as it is linked to a query that
defines the value of a textbox later in the form. However, is there a way I
can make a textbox equal the displayed value in the combobox, ie: column 1?

What I am looking for is some VBA code to make a new textbox, called:
Product_Code = Combo16's displayed value

I am completely stuck but desperately need this, so any help would be
completely appreciated
Use the Column() function, e.g. bind =ComboBox16.Column(1) to a
TextBox's control source or use it in a VBA procedure.


mfG
-- stefan --