want blank fields when form is first opened

[atadbitslow]

I have a form that has a query for the recordsource. This form has a combo box that the user selects a person from and the fields on the form display that person's data.

my question is--when the form is first opened, it displays the data for the first person in the recordsource--is there an easy way to have the fields be blank when the form is first opened?

thanks!

 

[Page410]

You could set the criteria in your query to be the value in the combo box and set the default value of the combo box to "" or null or some value that won't register a hit in the query.
Don't forget to requery on the AfterUpdate event of the combo box.

 

[Plumes]

You could try setting the Data Entry criteria for the form to "Yes", then is will open on the next blank/empty record.

Matt