clear userform

[p4nny]

Hi,

Is it possible to have a button that will clear the contents entered on to an access userform?

Is there vba code that would sit behind the button?

Many thanks

 

[alansidman]

Please explain more fully the rationale and how this will be used. Are you looking to delete a record that already exists or are you looking to clear data that has been entered and not yet been updated to the bound table. Need more information to provide a solution.

 

[HiTechCoach]

In Excel and Word there are UserForms. Access forms are much more powerful. You should have your Access form bound to a query or table. This is much different that than how a Word/Excel Userform works.

To get the full power of an Access form you will need to set the form's record source so it is bound to a table or query. By doing this Access will automatically save the data to the table and clear the form when you move to a new record. AN Access bound form (set the record source) can Create, Read (display), Update and Delete (CRUD) data in a table without adding any buttons ore VBA code!