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
|
|||
|
|||
In MS Access I want form to be open for fresh record entry
Hi,
In MS Access when I am opening any form for new Record entry so I want the fform to be opened for fresh entry only. For Eg: Suppose there are 8 records in a the Table and when I am opening the form for 9th Entry the Blank 9th record for entry should get open, it should not open on 1st record. Regards, George |
#2
|
|||
|
|||
In MS Access I want form to be open for fresh record entry
Set the Form's DataEntry property to True.
"George" wrote in message ... Hi, In MS Access when I am opening any form for new Record entry so I want the fform to be opened for fresh entry only. For Eg: Suppose there are 8 records in a the Table and when I am opening the form for 9th Entry the Blank 9th record for entry should get open, it should not open on 1st record. Regards, George |
#3
|
|||
|
|||
In MS Access I want form to be open for fresh record entry
If you ***only*** want the form to be used to add records, Baz's advice is
right on the mark! If you want the form to ***open*** on a new record, but also want to be able to use it to see the existing records, use this code Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub -- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200801/1 |
Thread Tools | |
Display Modes | |
|
|