Mr John,
Although i am a novice access user, i managed to prepare a table, query and search form using like[forms]![formname]![fieldname]&"*".
I need your advice on modifying the search form, i went through the sample database you provided, but since iam not acquainted with VBA, couldn't grasp...