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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cascading Combo Boxes in Main Form 8
Form Filter question 1
Filter 2nd form based on a field value of 1st form 0
Combo Boxes that filter database 3
Filter Form then Select a Filtered Record for view 1
Performance question 5
Filter a report based on combox value 4
Resetting Filter (Combo Box) to All 3

Top