Clear Form

[chrisbird13]

Hello,

I would like to put a button on a form I am making so that you can clear it without saving the data.

eg you open the form input a load of data, it is all wrong so you click clear form and start inputting data again

I have the button what do i need to do to get it to do this

Thanks

Chris

 

[KeithG]

I made an example for you

 

[chrisbird13]

i cannot get your example to open, could you please explain?

 

[KeithG]

I made an unbound form with three textboxs and two buttons. One button would clear the form and the other would run an append query to append the data from the form to a table. Below is the SQL statement from the append query.

INSERT INTO tblTest ( [Date], Name, Wage )
SELECT Forms!frmSample!txtDate AS Expr1, Forms!frmSample!txtName AS Expr2, Forms!frmSample!txtWage AS Expr3;

 

[Smart]

I personally would have the form based on the table or preferably a query

create a button using the wizard and select record operations then undo record. this will undo any entries in the form

create a button again using the wizard select record operations then save record