Canel without updating database

[Paul Byford]

I have a form which when opened, inputs the current date
by default. I want to be able to cancel the input and
close the form with saving the record with the date only.

I have tried the DoCmd.CancelEvent followed by
DoCmd.Close, but the record is saved with only the date
field.

Ideas???


Thanks in advance.

 

[Rick Brandt]

I have a form which when opened, inputs the current date
by default. I want to be able to cancel the input and
close the form with saving the record with the date only.

I have tried the DoCmd.CancelEvent followed by
DoCmd.Close, but the record is saved with only the date
field.

Instead of "setting" the value to the current date use a default value
property of Date(). That way a new record is not created unless the user
enters data in some other control.

 

[Paul Byford]

I have the default value set as =Date() and this problem
still exists.

Cheers

 

[Paul Byford]

After looking through the many posts here, I found one
with the answer. Me.Undo followed by DoCmd.Close

Cheers