Getting a form to open at new record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Seamus - 29 Mar 2005 18:57 GMT

I have a form opening at startup. I would like to have
this form immediately go to the new record position. I
know that the shortcut to do this is <Ctrl> + +, but is
there a way to make it happen automatically?

Thanks,
Seamus

Reply to this Message

Brian - 29 Mar 2005 19:06 GMT

> I have a form opening at startup. I would like to have
> this form immediately go to the new record position. I
[quoted text clipped - 3 lines]
> Thanks,
> Seamus

Set the form's Data Entry property to Yes

Reply to this Message

Ken Snell [MVP] - 29 Mar 2005 19:07 GMT

If all you want is a new record, set the form's DataEntry property to Yes.

Signature

Ken Snell
<MS ACCESS MVP>

>I have a form opening at startup. I would like to have
> this form immediately go to the new record position. I
[quoted text clipped - 3 lines]
> Thanks,
> Seamus

Reply to this Message

PC Datasheet - 29 Mar 2005 19:12 GMT

Setting the DataEntry property to Yes won't allow you to navigate back to
previously existing records. If you want to be able to do that, put the
following code in the form's Open event:
DoCmd.GoToRecord,,acNewRec

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com

> I have a form opening at startup. I would like to have
> this form immediately go to the new record position. I
[quoted text clipped - 3 lines]
> Thanks,
> Seamus

Reply to this Message