HELP with Code to Cancel Record & Keep Data

[RosieLavoie]

Hi,

need help with the following:

Access database: when entering in a preset form, it is determined it is not required but would like to retain the data entered but cancel the record, can this be done?

Essentially would like it to do the following:

OnClick
DoCmd.SaveRecord
DoCmd.CancelRecord
DoCmd.MovetoNewRecord

Please help, I have been stuck and not able to use database

thank you,

[twinnyfo]

Rosie,

Welcome to Bytes!

Would you be able to clarify exactly what you mean when you say:

it is determined it is not required but would like to retain the data entered but cancel the record

If the data is not required, then why keep it? If you're keeping it, then just keep it!

I think further clarification would be required for us to give you any meaningful assistance.

Thanks for your clarification.