Clear Data

[Saxman]

I would like to put a command button on a form that would clear all the
data for the record shown.

What is the best way to proceed please?

 

[John Vinson]

I would like to put a command button on a form that would clear all the
data for the record shown.

What is the best way to proceed please?

Clarification:

Do you want to erase the data currently stored in your Table for that
record?

Do you want to erase the data that the user has added or changed for
the current record and go back to editing the same record again, from
scratch?

Or do you want to move to the new record, saving the work that has
been done on this record?

All three are possible but require different actions.

John W. Vinson[MVP]

 

[Saxman]

Do you want to erase the data currently stored in your Table for that
record?

That's the one. I knew it wasn't easy!

Thanks.

 

[John Vinson]

That's the one. I knew it wasn't easy!

Thanks.

Rather than leaving the record in the table, with all blank records,
might it not be better to delete the record? Or do you want to reenter
all new data for the record?

Please explain the real-world situation. I don't want to mislead you
based on a misunderstanding!

John W. Vinson[MVP]

 

[Saxman]

Please explain the real-world situation. I don't want to mislead you
based on a misunderstanding!

I have managed to sort it using a command button wizard.

Thanks.