Aug 21, 2006 #1 lconte Technical User Joined Aug 21, 2006 Messages 3 Location US I have the save button and it writes to a table but i also want it to clear the form. This form is mainly being used for data entry. Any ideas?
I have the save button and it writes to a table but i also want it to clear the form. This form is mainly being used for data entry. Any ideas?
Aug 21, 2006 #2 Remou Technical User Joined Sep 30, 2002 Messages 13,030 Location BE Loop through the controls collection? Upvote 0 Downvote
Aug 22, 2006 #3 jkl0 Technical User Joined Oct 12, 2005 Messages 143 Location US DoCmd.GoToRecord , , acNewRec Hope this helps? Upvote 0 Downvote
Aug 28, 2006 Thread starter #4 lconte Technical User Joined Aug 21, 2006 Messages 3 Location US THANK YOU, THANK YOU!!!! The DoCmd.GoToRecord, , acNewRec worked! Upvote 0 Downvote