Filtering on a user-defined field

I have a form that shows three related tables in a contacts database, two in subforms. This works fine.
Because the standard filtering is a bit user-hostile I have added a text field (in the form footer) in which the user can specify a surname, and then click on a checkbox to activate the filter, which should then show the first record that corresponds to the selected name, or the next one if there is no exact match, and thereafter show successive matching records as the user selects 'next'.
The code works from the click field, and attempts to create a SQL statement to select the first valid record using the data in the text field. This is as far as I have got.
This is probably pretty simple, but I am unable to find a way of redisplaying the form just to show the filtered fields. Do I need to create a recordset for the filtered records? How do I refresh the form?

Julian,

Put the sql that was created as the record source for your form and then requery the form.

lwells