hello guys need a help here,

got a table with 7 fields, then a form with a subform and unbound textbox. i place the unbound textbox in the details part since if i will put it in the header it will not appear during run time.

the subform still in the details view, i want to display only 3 fields in it(id, name and address) and the records base on the select comand that i put in the change function. the code are:

Private Sub Text18_Change()
Dim strWhere As String
Dim lngLen As Long
Const conJetDate = "\#mm\/dd\/yyyy\#"



strWhere = strWhere & "([studs.name] Like ""*" & Me.Text18 & "*"")AND "
Me.RecordSource = strWhere

Me.Filter = strWhere
Me.FilterOn = True

End Sub

my purpose is, everytime i type a character in the textbox all the records that their name containing the character i type will be displayed automatically in the subform.

thank you inadvance guys... and God bless...