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