N nrmarthi Registered User. Local time Today, 04:54 Joined Feb 13, 2006 Messages 47 Apr 5, 2006 #1 Hello guys I have one small quick question. How can get blank or new record after saving Cheers
Smart Registered User. Local time Today, 11:54 Joined Jun 6, 2005 Messages 436 Apr 6, 2006 #2 after the save close the form and then open the form
ghudson Registered User. Local time Today, 06:54 Joined Jun 8, 2002 Messages 6,194 Apr 6, 2006 #3 Smart said: after the save close the form and then open the form Click to expand... Smart, you are kidding...right? nrmarthi, use this in your Save() button... Code: DoCmd.RunCommand acCmdSelectRecord [COLOR="Green"]'you probably do not need this line[/COLOR] DoCmd.RunCommand acCmdSave DoCmd.RunCommand acCmdRecordsGoToNew
Smart said: after the save close the form and then open the form Click to expand... Smart, you are kidding...right? nrmarthi, use this in your Save() button... Code: DoCmd.RunCommand acCmdSelectRecord [COLOR="Green"]'you probably do not need this line[/COLOR] DoCmd.RunCommand acCmdSave DoCmd.RunCommand acCmdRecordsGoToNew
N nrmarthi Registered User. Local time Today, 04:54 Joined Feb 13, 2006 Messages 47 Apr 7, 2006 #4 Thank you Ghudson its working Cheers