That would give him what he wants, but he wants the information that is already hidden in the structure of the listbox without making another pass at the DB. This workaround will do fine until the property is exposed on the lookup listbox.
----- Original Message ----- From: "Victor Timmons" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, September 28, 2004 1:57 PM Subject: [RBG7-L] - Re: Get count of items in Listbox > Ok im shooting from the hip here. > > A lookup list box would get its data from a table in the database right. > why not do something like this > > SELECT COUNT(*) INTO .vCount FROM TableName WHERE (same where clause as > list box if there is one) > > Just make sure its counting the same data as the listbox is showing > > Then refresh the form > > > On 28 Sep 2004 at 9:44, Lawrence Lustig wrote: > > > Is there a way to extract the count of items in the various Lookup List Box > > controls (something like an ItemCount property that can be read)? > > -- > > Larry > > > > > > > > Victor Timmons > Tiz's Door Sales, Inc > 425-258-2391 >
