DoCmd.ApplyFilter Issue

[obheron]

I keep getting a syntax error with this line of code.
Any suggestions?

DoCmd.ApplyFilter([FruitFilter],[Forms![Fruits]![Fruit]= "Apple")])

 

[PHV]

I'd try this:
DoCmd.ApplyFilter , "Fruit = 'Apple'"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[obheron]

Tried that line and no error. But also no filter.

The filter event is the result of an option button being clicked. I am trying to apply the filter to a subform, in the form the option box is.

Any suggestions?

 

[PHV]

Something like this ?
With Me![subform control name].Form
.Filter = "Fruit = 'Apple'"
.FilterOn = True
End With

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886