This works fine, but relies on inputting the full name and correct spelling of the name.

prompt = "Enter a name to search for"
title = "NAME SEARCH"
employee = InputBox(prompt, title)
search = "Name = '" + employee + "'"

' Find the record
Data1.Recordset.FindFirst (search)

Could someone give me a (search =) line that assuming a name was joe bloggs would find the record if just "joe" or "bloggs" was entered.

Any help appreciated

GRAHAM