Hi
I am having a problem with getting this one to work. I am trying to combine the values from 2 fields into 1 (one of these is a textbox, and the other is a combobox).
The problem is with the combobox side. My combobox (called Name) has 2 columns (ID and Title). I can get it to merge the ID with my textbox (called nameLevel) using this code as the control source.
=[Name] & "" & [NameLevel].
Which leaves me with a value made up of ID and Name Level. What i need is to end up with the value showing as Title and Name Level.
I have tried adding in the .column(1) after the field name but this only returns an error message.
Any suggestions as to where im going wrong with this.
Cheers
I am having a problem with getting this one to work. I am trying to combine the values from 2 fields into 1 (one of these is a textbox, and the other is a combobox).
The problem is with the combobox side. My combobox (called Name) has 2 columns (ID and Title). I can get it to merge the ID with my textbox (called nameLevel) using this code as the control source.
=[Name] & "" & [NameLevel].
Which leaves me with a value made up of ID and Name Level. What i need is to end up with the value showing as Title and Name Level.
I have tried adding in the .column(1) after the field name but this only returns an error message.
Any suggestions as to where im going wrong with this.
Cheers