Listbox and Textbox

  • Thread starter Thread starter Asif
  • Start date Start date
A

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
 
Asif said:
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
Click to expand...


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