Filtering a subform

[Jarvonimbus]

I'm trying to apply a filter to a subform based on the entry given in an inpout box when you click a button. The subform says that it is filtered but all records are still visible!
This is the code on the button - can anyone advise please?
Many thanks

Criteria = InputBox("Enter Dealership")

[Forms]![FrmBrowser]![FrmBrowser subform].Form.Filter = [Forms]![FrmBrowser]![FrmBrowser subform]![Dealership] = Criteria

[Forms]![FrmBrowser]![FrmBrowser subform].Form.FilterOn = True

 

[PHV]

You may try this:
[Forms]![FrmBrowser]![FrmBrowser subform].Form.Filter = "Dealership='" & Criteria & "'"

Dealership should be the name of the field in the underlaying Table/Query.
If Dealership is defined as numeric then get rid of the single quotes.

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

 

[Jarvonimbus]

That's the one! Thank you very much