Filter by comboBox value

[blueraincoat]

Hi all, I'm working a form with filter by comboBox, my purpose is that after the comboBox updated, the form will show related data. See attached picutre, the code i wrote is

Private Sub Combo9_AfterUpdate()


Form.filter = "RepairID = '" & Me.Combo9.Value & "'"
Form.FilterOn = True

End Sub

There's something wrong, the filter did not work...
Could somebody give me some suggestion?
Thanks in advance

[pbaldy]

Is that on the same form or a subform? This

Form.filter

either needs to be

Me.Filter

or a reference to the subform's filter:

Forms Refer to Form and Subform properties and controls

[blueraincoat]

Thank you Paul.
But it still did not work. The ComboBox is on the page header of the form.
I upload a sample db,could you take a look and help find what's wrong?

[pbaldy]

The after update event is running an embedded macro, not the code. You may need to rebuild the form; it got corrupted on me when I tried to change it to the code.

[blueraincoat]

Yes you are correct, it works after i change the property of the after update event.
I don't when i changed that property...
Thank you Paul.

[blueraincoat]

I found the root cause, when I added the ComboBox, ACCESS let me make a decision, and that made the afterupdate event of the comboBox run a embeded marco.

[pbaldy]

Glad we got it sorted out.