Event Procedure to filter records on a form

[verdes]

I have an unbound text box (in the header) that I want to use to filter records on a split form.

I want the user to enter a number in the textbox and have the form return records that match the number. The filtered field is a number in my database. I don't want to use a combo box.

I want to have an ON Change event procedure that sets Me.Filter. I can't get the syntax correct to pass the textbox value.

Any help you give will be appreciated. I'm usning MS Access 2007.

 

[John Big Booty]

The attached sample dynamically filters a sub form but you should be able to apply the same principals to a split form.