Listbox

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

Hi
I am stuck with some code and would appreciate if anyone could help. I
am using a tab control on my form. The first tab has the text boxex etx
in which I enter my data into the table. The second tab has a
multi-column listbox in which all the data in my table is displayed. I
want to be able to click a record on my listbox and have the data
displayed in my text boxes.

Can anyone help please
 
I am not sure I understand but if all you want it to open

List box on TABLE A named combo1

Open form 1 from table 1

form1.field 1 = combo1.column(1)

You may have to use the following if that does not work

Me.Field1 = combo1.column(1)

Counting for columns starts at zero just add this coding to the afterupdate
event and when you select a row or record in the combo box it will fill in
the screen records....
 
Back
Top