>>>>>>>>How do you grab the contents of a column in a combo box and put
>>>>>>>>it into a memory variable. I am trying to assign column 2 to a memory variable.
>>>>>>>
>>>>>>>Basically, when you pick up an item from Combo, you get element of RowSource (e.g. moving pointer to specific record if RowSource is alias or field). So you can fill memory variable with the rowsource value, or don't use variable at all because RowSource is always available.
>>>>>>
>>>>>>can you please, show me some code that will display the rowsource of column 2 of a combo box that will show what the user picked from the combo box?
>>>>>
>>>>>To give you code example, I have to know at least what RowSource you are using.
>>>>
>>>>thanks Edward.. my rowsource in my property sheet for the combo I am talking
>>>>about is... emp_name.name,office_num
>>>
>>>Well, we are moving ahead... So, the next simple question: what and where you want 'to display'? I guess what the problem is, but... let be consistent. If you want to display in 'text portion of the combobox', reply using exactly this definition, please!
>>
>>OK.. thanks... My combo box called COMBO_EMP_NAME and has a two columns. The user makes a selection from the combo box. My next field on the FORM is called
>>TXTOFFICE_NUM. I need column 2 of COMBO_EMP_NAME to be the new value of TXTOFFICE_NUM. TXTOFFICE_NUM is read only.
>
>Great! The answer is following:
>**Combo.InteractiveChange Event:
>Thisform.TXTOFFICE_NUM.value= emp_name.office_num

It works....thanks..you helped a lot on this one...I know what you
are thinking... YOU SHOULD READ MORE, ROB... thanks again...