Opening a database with a new form

Hi

I am creating a database in which when users open it, it defaults to a
single form. At the moment, when they open it, it opens on a record.

Is it possible to open it so that it's a new form (i.e. record) instead of a
previously created record

Thank you in advance for your help.

You can set the data entry property of that form to No.
It will open ready to add a new record.

If you want users to be able to go back to other records, you can use code
in the load event to make the form go to a new record (without setting the
data entry property to No).

DoCmd.GoToRecord, , acNew


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"forest8" wrote in message
...
Hi

I am creating a database in which when users open it, it defaults to a
single form. At the moment, when they open it, it opens on a record.

Is it possible to open it so that it's a new form (i.e. record) instead of
a
previously created record

Thank you in advance for your help.

This is exactly what I needed. Thank you

"Jeanette Cunningham" wrote:

You can set the data entry property of that form to No.
It will open ready to add a new record.

If you want users to be able to go back to other records, you can use code
in the load event to make the form go to a new record (without setting the
data entry property to No).

DoCmd.GoToRecord, , acNew


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"forest8" wrote in message
...
Hi

I am creating a database in which when users open it, it defaults to a
single form. At the moment, when they open it, it opens on a record.

Is it possible to open it so that it's a new form (i.e. record) instead of
a
previously created record

Thank you in advance for your help.




.

Hi Jeanette -

I think that should be "...set the data entry property of that form to Yes"

John



Jeanette Cunningham wrote:
You can set the data entry property of that form to No.
It will open ready to add a new record.

If you want users to be able to go back to other records, you can use code
in the load event to make the form go to a new record (without setting the
data entry property to No).

DoCmd.GoToRecord, , acNew

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi

[quoted text clipped - 6 lines]

Thank you in advance for your help.

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201003/1

Thanks for spotting that.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"J_Goddard via AccessMonster.com" u37558@uwe wrote in message
news:a4b7d51cbf6c4@uwe...
Hi Jeanette -

I think that should be "...set the data entry property of that form to
Yes"

John



Jeanette Cunningham wrote:
You can set the data entry property of that form to No.
It will open ready to add a new record.

If you want users to be able to go back to other records, you can use code
in the load event to make the form go to a new record (without setting the
data entry property to No).

DoCmd.GoToRecord, , acNew

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi

[quoted text clipped - 6 lines]

Thank you in advance for your help.

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201003/1