"DoCmd.GoToRecord , , A_NEWREC " what action will be taken when this stmt executed

[patelnitesha]

"DoCmd.GoToRecord , , A_NEWREC " what action will be taken when this stmt executed

hi

could you please tell me what action will be happned when this both statement executed..

DoCmd.GoToRecord , , A_NEWREC
SendKeys "%N", True

Form ahse defines these statement as well.

Option Compare Database
Option Explicit

 

[The_Doc_Man]

Without more information on the surrounding code and context, this question is not answerable.

 

[Moniker]

The DoCmd.GoToRecord , , A_NEWREC navigates to a new record on the current form (like clicking the * in the navigation bar).

The SendKeys %N, True sends Alt-N, which makes a little "ding" noise, presumably there to give an audio cue that you're at a new record. The "TRUE" after the %N means "play the noise before returning control to the DB".

Option Compare Database defines the way that searches and matching are executed.

Option Explicit means that you must explicitly define a variable before using it.

FYI, all of this stuff is in Access Help.