Opening a database with a new form

[forest8]

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.

 

[Jeanette Cunningham]

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]

This is exactly what I needed. Thank you

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





.

 

[Jeanette Cunningham]

Thanks for spotting that.

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

Hi Jeanette -

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

John

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