E
erdo
Hi,
I have a data entry form with one listbox and several
combo boxes. There is an ID_cbx combo box where user
supposed to enter ID number. Since it is hard to remember
ID number I put a listbox on the form so that user can
choose the record by scrolling up and down on the
different records which include name, lastname etc. I
wanted user to select a record from the listbox and see
the ID number in ID_cbx combo box. I achieved to do all
those with query and macros. But what I could not find out
is how to see that value in the ID_cbx combo box without
clicking on the arrow. First row of the combo box is
always blank. As soon as I click on a record in the
listbox the value should show up in the combo box textbox
portion (not listbox portion).
Thank you very much for your help.
I have a data entry form with one listbox and several
combo boxes. There is an ID_cbx combo box where user
supposed to enter ID number. Since it is hard to remember
ID number I put a listbox on the form so that user can
choose the record by scrolling up and down on the
different records which include name, lastname etc. I
wanted user to select a record from the listbox and see
the ID number in ID_cbx combo box. I achieved to do all
those with query and macros. But what I could not find out
is how to see that value in the ID_cbx combo box without
clicking on the arrow. First row of the combo box is
always blank. As soon as I click on a record in the
listbox the value should show up in the combo box textbox
portion (not listbox portion).
Thank you very much for your help.