Using VBA to filter a textbox on a form

[RXX00]

I have a form and the record source is a table.

I want the user to input a value into a blank textbox, I then need VBA to use that value to filter a field on the form.

Any ideas?

 

[Trevor G]

Is the form a Continuous form and do you want to filter after you have entered something in the text box or from a command button, it would be useful for a little more of a description to help us create a solution for you!

What have you tried so far?

 

[kemas]

Private Sub Text219_AfterUpdate()
Me.Form.Filter = "saff=" & Me.Text219
Me.Form.FilterOn = True
End Sub

 

[speakers_86]

Your filtering a textbox based on a textbox? That seems odd to me. Maybe you should consider using combo boxes instead.

 

[smig]

you can filter a subForm based on a text box (unbounded one) on the top form