Listbox and Textbox

[Asif]

I have a listbox and a textbox in a form the listbox contains three
columns; ID, DATE and QUANTITY when I click on an entry in the listbox
the textbox displays the ID related to the entry highlighted. The
on_click event of the listbox is a macro with the following condition

ITEM:- [Forms]![frm_edit]![Text4]
EXPRESSION :- [Forms]![frm_edit]![lst_Process Date]

Instead of Text4 picking up the ID field I want it to pick up the Date
Field.

Any suggestions??

Thanks

 

[Storrboy]

I have a listbox and a textbox in a form the listbox contains three
columns; ID, DATE and QUANTITY when I click on an entry in the listbox
the textbox displays the ID related to the entry highlighted. The
on_click event of the listbox is a macro with the following condition

ITEM:- [Forms]![frm_edit]![Text4]
EXPRESSION :- [Forms]![frm_edit]![lst_Process Date]

Instead of Text4 picking up the ID field I want it to pick up the Date
Field.

Any suggestions??

Thanks

ITEM:- [Forms]![frm_edit]![Text4]
EXPRESSION :- [Forms]![frm_edit]![lst_Process Date].Column(1)