New Record Macro (toolbar)

[T588]

What action argument would I use to clear all fields in an active form?

I created a toolbar named "new record" upon clicking - I want this to run a macro that if all required fields are not filled it will clear all fields in the active form. As it stands now, it moves to a new record and the incomplete record is placed in the table.

How would I do this?
any help would be appreciated.
Thank you
Vince

 

[jfgambit]

You want to add code to the form that checks for the incomplete fields and then updates the information. Before I send you the code I have a small question. Why do you want to remove all the information that someone has entered? Wouldn't it be better to let them know they missed a field and that it needs to be filled out? Why make them re-enter all the data all over again?

Just curious...