"Pierkes" wrote in
:

So the only problem i have is on opening the form. Is it possible
to open the form without it being filled with data of a certain
record (so is see a blank form) ?

Use a recordsource like this, where "MyTable" is the smallest table
in your application, and the fieldnames are the fields controls on
the form are bound to:

SELECT TOP 1 Null As Field1, Null As Field2, Null As Field3
FROM MyTable

This gives you a single blank record that is uneditable. You would
then change the recordsource in the code that does the search.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/