problem with items in listbox not displaying

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have listbox in my form. When the form opens my listbox shows all items.
When I apply filter to my listbox results are random, sometimes it displays
all required items, sometimes not. What is the source of this problem and how
I can fix it.

I am using Access 2000 on Windows 2000.

Thanks for help.

Tony
 
How are you applying the filter to the listbox? How many columns are in the
listbox? If more than one column, which column is the bound column?
 
you can do two things.
1. Create the query and assign to your list box. Make sure the column
on your query match with the column on your list box.
2. put the select statement for your list box property.

Hope it helps.
 
Back
Top