J junmart Registered User. Local time Today, 17:10 Joined Sep 14, 2001 Messages 29 May 25, 2002 #1 what code do i need to put in my form's "on open" property so that my form goes to a new record everytime it opens. thanks.
what code do i need to put in my form's "on open" property so that my form goes to a new record everytime it opens. thanks.
S scottfarcus Registered User. Local time Today, 17:10 Joined Oct 15, 2001 Messages 182 May 25, 2002 #2 Recordset.AddNew
L llkhoutx Registered User. Local time Today, 11:10 Joined Feb 26, 2001 Messages 4,018 May 25, 2002 #3 I think that it's: DoCmd.GoToRecord , , acNewRec
Fornatian Dim Person Local time Today, 17:10 Joined Sep 1, 2000 Messages 1,396 May 25, 2002 #4 If the form is ONLY used for data entry you could also set data-entry to Yes, this would automatically go to a new record without code.
If the form is ONLY used for data entry you could also set data-entry to Yes, this would automatically go to a new record without code.
