469,326 Members | 1,359 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,326 developers. It's quick & easy.

save record and next record in one button

Hi
How can i put save record and next record in one button.
in my save record i put the calculation of the text boxes. i have a total field that the sum of the other field is in there and it wil be filled when i push the save button. and the sum will go and save in a table. but now the new requirment is that i put save record and next record in one button to be easier for the user.
i was using the next record seperately.
thanks for the help.
Feb 27 '07 #1
2 9437
ADezii
8,800 Expert 8TB
Hi
How can i put save record and next record in one button.
in my save record i put the calculation of the text boxes. i have a total field that the sum of the other field is in there and it wil be filled when i push the save button. and the sum will go and save in a table. but now the new requirment is that i put save record and next record in one button to be easier for the user.
i was using the next record seperately.
thanks for the help.
Expand|Select|Wrap|Line Numbers
  1. 'Save the Record
  2. DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
  3. 'SendKeys "+{ENTER}", True  'will work also
  4.  
  5. 'Go to the Next Record. If on the Last Record,
  6. 'will Add a Record
  7. DoCmd.GoToRecord , , acNext
Feb 27 '07 #2
thanks alot
Feb 27 '07 #3

Post your reply

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

Similar topics

3 posts views Thread by William Wisnieski | last post: by
27 posts views Thread by Kim Webb | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
reply views Thread by listenups61195 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.