Blank Listboxes 2

[RussOSU]

I am creating a form which includes a couple textboxes in which information will be entered and used to filter data in a table. The information I want displayed in a listbox also located on that form. Is it possible to have the listbox unpopulated till one of the filters is activated and depopulated with the use of a button to clear the form?

Russ

 

[FancyPrairie]

Initially, leave the RowSource property blank. Then, after the filter is applied, set the RowSource property of the list box to what you want (query, etc). When you don't want anything to show in the list box, set it's RowSource to vbNullString.

 

[rdodge]

When you want the listbox to be unpopulated, set the RowSource Property to an empty string ("&quot, and when you want the Listbox to be populated, set the RowSource to a Table Name (RowSourceType = "Table/Query&quot, Query Name (RowSourceType = "Table/Query&quot, SQL Statement (RowSourceType = "Table/Query&quot, or put the values in itself with a semi colon between each item (RowSourceType = "List Values&quot

Note, the RowSource and RowSourceType Property of a listbox are String Data Type format.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000

 

[RussOSU]

Thank you guys. That helps a lot.

Russ