Clear a form on opening

[MartinGM]

I have a simple form based on a query, all the fields being defined by the value in a ComboBox.

I can easily clear the form by setting the value in the ComboBox to "" and taking it from there.

But I would prefer the form to be clear when it opens, so in the form's On Load event I cleared the ComboBox. Although the rest of the On Load code runs correctly, clearing the ComboBox doesn't happen and the form opens with the first record showing. I guess that the first record is selected after the On Load code runs ?

Is there an easy way to fix this ?

Thanks

Martin

[OBP]

Try the "On Open Event" instead.
However you may get an error from the On Current code which sets the combo to the current record.

[MartinGM]

Try the "On Open Event" instead.
However you may get an error from the On Current code which sets the combo to the current record.

No errors, but no result either :(

[OBP]

OK, you could open a new record, that would give you a blank form.

DoCmd.GoToRecord , , acNewRec

[MartinGM]

Ingenious - and successful - thank you.