Discussion Locked
0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am a new user to Access. I have created a table to store inventory data that will be input from a form that I have also created. I would like to be able to have the users input the data into the form, save it to the table then clear the form to input the same data for another department. Then save this to the table. All data can be stored together in this same table so that is not a concern. The form works fine except for clearing the data. It creates a new record every time I go in but from the previous data entry point. This form will be used at least twice a month and it seems unnecessary to begin at the end of the records every time. Not to mention the number of records it will accumlate. Can I save the data and clear the form for new data entry and if so how? Thank you.
3 replies
by timfox
The New button >* should already do what you need (add record, clear form, allow user to input another record).
It sounds like the form is opening up at the last record in the source recordset. If you want the form to open at a new record, then set the OnOpen event to do the following:
DoCmd.GoToRecord , , acNewRec
Add this code to the OnClick event of a button to provide the SaveThisRecord and GoToNewRecord action.
hope it helps
TimFox
by p_cheatum
Poster rated this answer
by p_cheatum
This question was closed by the author
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
Question Unanswered
Icons, favicons and merch graphics on Squarespace: my workflow for getting
1 helpful
0 replies
0 helpful
20 replies
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
Discussion
Network Printer Works for Everyone Except Me
0 helpful
10 replies
0 helpful
4 replies