Clear Data

S

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?
 
J

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?
Click to expand...

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]
 
J

John Vinson

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

Thanks.
Click to expand...

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]
 
S

Saxman

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

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

Thanks.
 
Top