-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
clear userform
- Thread starter p4nny
- Start date
alansidman
Well-known Member
- Joined
- Feb 26, 2007
- Messages
- 8,456
- Office Version
- 365
- Platform
- Windows
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.
Upvote
0
HiTechCoach
Well-known Member
- Joined
- Aug 29, 2010
- Messages
- 1,008
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!
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!
Upvote
0
