Show how many results were filtered in a listbox 1

[nim180]

Hi Everyone, im hoping someone can help me with the following. I have a form with a text box, a list box and a command button. When i type something into the textbox and press the command button it populates the listbox with all the information regarding what was entered in the textbox.

For example if i type "John" into the textbox the list box will bring up all the John's in the table.

I have all that working but i would like to do the following: if for example the listbox shows 3 results, i need something like a textbox under the listbox to say "Search has brought back 3 results". Can someone help me with this, thanks in advance.

Nim

 

[Remou]

You can use the ListCount property:

=lstList.ListCount

You will need to subtract one (1) if you are using column heads.

 

[nim180]

thanks remou got it working have a star!

Nim