ListBox Problem

  • Thread starter Thread starter stelios
  • Start date Start date
S

stelios

Hi,
I have the following code to fill a list box:

With RSSerchKartela
.MoveLast
.MoveFirst
Do Until .EOF
Me.[lstResults].Column(0) = KartID
Me![lstResults].Column(1) = !AM
Me![lstResults].Column(2) = !Kathgoria
Me![lstResults].Column(3) = !Bathmos
Me![lstResults].Column(4) = !Epwnymo
Me![lstResults].Column(5) = !Onoma
Me![lstResults].Column(6) = !Patronymo
.MoveNext
Loop
Me.txtCount.Value = .RecordCount
End With

But I don't get results, I get a run time error ('424' an object required)!
Whats going wrong?
What I have to change for filling the list box?

stelios
 
To show/hide columns You need to set RowSource = "SomeQueryOrTable
Next, You can set columnWidths = "0;1,5;2;5;0;0;5" to hide columns 1, 4, 5 and show columns 2, 3 and

To fill Listbox and combobox in Access there is different way than in other Office apllications
 
Back
Top