OnChange filter

[Dave Eyley]

Ok, I have code that is supposed to check for changed in a text box called 'Member' and apply a continuously updating filter to to a sub form...
the code is -

OnChange -

Forms!AAA!AAASub.Form.Filter = "[Surname] Like " & Chr(34) & Me!Member & "*" & Chr(34)

Forms!AAA!AAASub.Form.FilterOn = True

I thought it would update the filter with each new keypress, but it doesn't. It tries to do something if the 'enter key' is used but not what was expected and using the 'enter' key defeats the whole idea.

Ant thoughts anyone?

 

[MarkK]

Use the text property of the control. The default property is value, which doesn't change until afterupdate.

Forms!AAA.AAASub.Form.Filter = "[Surname] Like " & Chr(34) & Me.Member.Text & "*" & Chr(34)