By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,837 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Refresh Form after Enter data by click on submit button.

P: 101
My project is in MS Access.
In that I have one Form(DataEntry) which I am using for entering data into the Table(PRODUCTION).
Now after entering data in Textboxes when I click on Button(Submit) then it add data to my table.
Now I want that, When I click on Submit Button at that time first it add data to table and after that refresh the Form also at the same time.So I can add new data.
I know this is possible but I don't know how to do it.
So right now I am using Button(NewEntry) so when I click on it ,it will close the already open Form(DataEntry) and open the same Form(DataEntry) again.

Dec 18 '07 #1
Share this Question
Share on Google+
4 Replies

P: 365
DoCmd.GoToRecord , , acNewRec

just put that at the end of your submit button code and it will add andclear your data
Dec 18 '07 #2

P: 101
Thanks for ur reply.
Dec 18 '07 #3

P: 365
So it worked then (to your requirements)?
Dec 19 '07 #4

P: 101
Ya its working as per my requirement.
Dec 19 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.