displaying a form blank

[k_heppner]

I have a form that opens at startup. The user selects a value from a combo box and that populates the form's fields. I want all of the form's fields to be blank when the form first opens, (i.e. not have anything in them until a value is selected from the combo box). Right now all of the fields have data in them, but it is confusing and users forget to pick something from the combo box. Any help is greatly appreciated...

 

[Carol]

Go into your forms property sheet and enter "No" to Edit Records, "No" to Delete Records and "Yes" to Add Records. Or if this form is called from a main menu using the switchboard go back into the switchboard into the menu, edit the menu item to read Open Form in Add Mode Only.

Good Luck.

 

[CyVaquero]

Another possibility is to set the Record Source property to blank, and then set the Record Source property to the applicable Select..Where clause from the combo_change event.