Resetting form fields

[guamlet]

How do I set up a form to have all the fields reset to blank (just like a new record) when the form opens?

 

[Philem]

Hullo. In the OnOpen section for the form, put in Me.targetfield = null. That should do the trick. Curious, though: What is currently being shown when the form opens?

HTH

P

 

[guamlet]

Resetting Form Fields

When it opens, the first set of data from the table to which the form dumps its values is there. I wanted to start with a clean table, but I had to remove the ability to add new records due to a command button I installed to create new records based on multiple selections in a list box.

 

[guamlet]

I tried the null command, but it says that I can't assign a value to the object. I think that it's b/c it is a combobox that draws values from another table. I just want the form to look like I had never used it before, or like I had pushed the *> button.