Searching as user types

[speederpro]

Use the textbox onChange event.

e.g.
lastname_onchange ()

strsql = "select * from table where table.lastname like '"
& lastname.text & "*'"

tableform.recordsource = strsql
tableform.requery

end sub