How to wipe a form

[Paul H]

I have a data entry form with a Save Record button and a Close button. Right now if the user clicks the close button a partially entered records is put in the table. Do I have to wipe the form first using me.Field1 = "", me.Field2 = "" etc.? or something else?

Hope you can help,

Paul

[hertfordkc]

Did you put default values in the fields when you set up the form? (In the Property sheet)

[Paul H]

Yes, a couple of them.

[hertfordkc]

I misunderstood your question. Your are wanting to prevent the writing of an incomplete record to your table...right?
If so, I've handled that with VB code in the Form_BeforeUpdate event. If the entries are incomplete, Docmd.CancelEvent and DoCmd.Close (or other error handling).

[Paul H]

I misunderstood your question. Your are wanting to prevent the writing of an incomplete record to your table...right?

Yes

I've handled that with VB code in the Form_BeforeUpdate event. If the entries are incomplete, Docmd.CancelEvent

How do I define an incomplete record with a dozen field, but only 4 required?
Is there a better way than this?

 intResponse = MsgBox("Save record?", vbCritical + vbYesNo)
If intResponse = vbNo Then DoCmd.CancelEvent

[Paul H]

Really I need this to run off the cmdClose_click event. If they click the Close button the records never gets saved.

Even better, if I hit Esc (wiping the form clean), then click close, I get just the effect that I want.

[boblarson]

In the close button's click event you can use:

Me.Undo

[Paul H]

You're a gentleman and a scholar.

Thanks