clearing data entry forms

[simeon_rose]

can somebody tell me how i can set up a form, the data from which is entered into a table, but then deleted from the form. an example of what i want is a system that asks for details and then when 'submit' is clicked, these details are added to the table and cleared from the form. this way someone else can enter their details and can be sure of nobody else changing them as a prank. your help would be much appreciated.

 

[Richie]

You don't need to delete anything just base the form on your table and on the property sheet navigation buttons no. When you close the form it will save the record when you open it it will only have a blank record for a new entry if you wish to show all the records and be able to add just set the property sheet to data add, allow edits no, allow deletions no.

 

[simeon_rose]

thank you, thank you, thank you.