If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Opening a database with a new form
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. |
#3
|
|||
|
|||
Opening a database with a new form
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. . |
#4
|
|||
|
|||
Opening a database with a new form
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 |
#5
|
|||
|
|||
Opening a database with a new form
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 |
Thread Tools | |
Display Modes | |
|
|