Entering new record on form

[Diane]

How do I make the form go to a new record as I open it so
it is ready to fill in.

[Debra Farnham]

Hi Diane

On the On Open event of the form insert the following:

DoCmd.GoToRecord , , acNewRec

Assuming you're using Access 2000

HTH

Debra

"Diane" <illumin8_98@hotmail.com> wrote in message
news:025501c3470a$33e77e00$a301280a@phx.gbl...

> How do I make the form go to a new record as I open it so
> it is ready to fill in.

[John Vinson]

On Thu, 10 Jul 2003 10:39:24 -0700, "Diane" <illumin8_98@hotmail.com>
wrote:

>How do I make the form go to a new record as I open it so
>it is ready to fill in.

Two possibilities:

- If you JUST want to enter data, and don't want to even see old
records, set the DataEntry property of the Form to True.

- If you want to default to entering new records, but still want the
ability to scroll back and see old ones, put the following VBA code in
the Form's Open event (by viewing the form's properties, finding the
Open event on the Events tab, clicking the ... icon and choosing Code
Builder):

Private Sub Form_Open(Cancel as Integer)
DoCmd.GoToRecord acNewRecord
End Sub


John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
[url]http://go.compuserve.com/msdevapps?loc=us&access=public[/url]