Filtering Question

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.
 
M

Michel Walsh

Hi,


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


Hoping it may help,
Vanderghast, Access MVP
 
Top