DoCmd.GoToRecord , , acNewRec

[vagelisr]

Hi to all

I have a form and i want to move the cursor in the new record.

i use the command DoCmd.GoToRecord , , acNewRec

The command work great but my problem is this.
When i run the command in my screen i am able to see only the new record. To see older record i have to press page up

Is there any way to send the cursor in the new record without see only this??? (the new record i mean)

Thanks and regards!!!!

 

[Pat Hartman]

If you want a form to open to a new record and not show any existing records, set its AllowDataEntry property to Yes.

There is an option for this if you are using the Switchboard so you don't have to hard-code the property. The OpenForm Method can be used to open a form in DataEntry mode or edit mode and you can also use a Where argument so you can open at a specific record or filtered to a specific set of records if you use the Filter argument.

Take a look at the OpenForm Method description to see your options.