List Box contents deselect

  • Thread starter Thread starter Jenny
  • Start date Start date
J

Jenny

Hi,
I wanted to remove some rows from a list box contents
with 3 different column names, each row has no unique key
(ie. Data in the list box as below:
intYear strHomeGroupID strHomeGroupName
2002 000457700 ABCD
2002 000553300 BCDFGG
2003 000457700 ABCD )

which means if I use a find method, I have to have a
criteria looking for three columns for each row search.
Does anybody know how to solve this problem? Thanks,Jenny
..
 
Remove rows??? Your rowsource is where you set up the
values of a list box. Go to your properties and go to
the Data Tab and you will see rowsource. You can change
the rowsource by giving it a new query on either the form
or in VBA. If you wish to leave the rows in the list box
but you do not want to see the values, go to the format
tab and go to column widths. change the width to "0" for
the field you dont want to see. So, given the 3 fields
above, if you put 0";1";0" you will only see the second
field, even though the Bound Column will still be column
one (the default - which is changeable on the Data Tab).

So... depending on what you really want to have, there
are multiple ways of doing what you want. Also, the
filter will only (really stretching my brain) on the
field you write a string in the filter for.

Drew
 
Back
Top