Hi Rick,

I tried to reply to the group earlier but didn't see it appearing so here's
another go...

Thanks for your code, it works !

However, i do not use the DoCmd.OpenForm "FormName",,,"1 = 0" to open the
form but instead, to get the form to open in a subform, i use ;

SubFormArea.SourceObject = "Houses"

Any idea on how to adjest this code so it opens with a blank sheet ?
Thanks in advance,
Pierre


"Rick Brandt" wrote in message
...
Pierkes wrote:

Hi,

I have a form on which i present al lot of data from a database.
On the form is a comobox which i use to select the right record en
present
the data of this record on the form.

When i open de form, de combobox is empty (which is good !) but the rest
of the form is already filled with the data of a record in the database
(which is not good). When i choose a record for the combobox, the form is
filled with the data of that particular record (which is good).

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) ?

Help will be much appreciated!

Just open the form with a WHERE argument that has no records returned.

DoCmd.OpenForm "FormName",,,"1 = 0"

If you are using the bookmark method to show records with your ComboBox
change that to applying a filter for the desired record.

No need to mess with DataEntry mode or change Recordsets.