Blank Form on Startup

[jamesormi]

Hi,

I have a form that has a number of controls and a subform. When the form is opened by the user I would like the controls and the subform to be blank until the user has selected a value from a combo box.

Is there a simple way to do this?

Thanks in advance.

 

[John Big Booty]

If it's a data entry form you could use the following in the on Load event of the form;

docmd.GoToRecord acDataForm, "FRM_Name", acNewRec

 

[jamesormi]

docmd.GoToRecord acDataForm, "FRM_Name", acNewRec

I was using this method previously. The user may only want to review the data entered. At the moment the first record in the table is being shown. I would like it to be blank until the user selects a value in the combo box.