Filtering Question

  • Thread starter Thread starter Chaster
  • Start date Start date
C

Chaster

When I do a filter by selection I can see that the filter expresion in the
properties box is
(([California Only].ShowName="World Shoe Association"))

I would like to change the filter based on a combobox on my form but am
having problems with figuring out the vb syntax

My combobox is combo12 and the values in the box are text values. IE
"Imaging 203" or "Billard Congress Of America"

Any help would be appreciated.
 
Hi,


' Me.FilterOn=False
Me.Filter="FieldName=""" & Me.Combo12 & """"
Me.FilterOn=True


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top