I have an SQL statement with a WHEWRE clause within my VBA code. The idea is the user can search for data from a search form. If the search only returns 1 record how can I open a form based on that returned record.

ie if the search returns an employee ID on '10', is it possible to open the employees form at employee ID '10' from the recordset.

Any ideas?

Hope this makes sense?

Doesn't matterm I have figured it.

I uses the WHERE clause and specified it as a
the filter when I open my form.

Thanks anyway