I am using buttons to search for specific information. when the data is found it is displayed in a list box. I also need to display a total at the bottom of the box like total number of sites. Hown can i do that using code.
Button search
- Thread starter jrmellis
- Start date
Fizzio
Chief Torturer
- Local time
- Today, 07:29
- Joined
- Feb 21, 2002
- Messages
- 1,884
Create a textbox immediately below the listbox. In the Controlsource, enter
=[NameofListBox].[ListCount] & " Sites Found."
This will give you the number of records listed in your listbox.
HTH
[This message has been edited by Fizzio (edited 05-16-2002).]
=[NameofListBox].[ListCount] & " Sites Found."
This will give you the number of records listed in your listbox.
HTH
[This message has been edited by Fizzio (edited 05-16-2002).]
