Open form in LAST+1 (new) record

[Gilberto]

Hello

Is there a way to indicate a form that it should open in the LAST+1 record, so that the user can start entering information directly. Because right now when the user opens the form, it displays the first record information which by accident is always modified.

Thanks

[cyberdwarf]

Hi Gilberto,

Try using the DoCmd.GotoRecord statement. One of the parameters tells you which record to go to and includes the option "acNewRec".

HTH

Steve

[Gilberto]

Hi Gilberto,

Try using the DoCmd.GotoRecord statement. One of the parameters tells you which record to go to and includes the option "acNewRec".

HTH

Steve

Thanks cyberdwarf.

Im trying the following but its not working...it still opens on record #1...any ideas???

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

[cyberdwarf]

Gilberto

What is the data source of your form? (Please give full details)

Steve

[Gilberto]

Gilberto

What is the data source of your form? (Please give full details)

Steve

Hello,

Data source is: Engineering (which is the table containing all the fields in this form)
The data entry property of the form is set to: NO

I have already 195 records saved. I tried enabling the DATA ENTRY but then the 195 records "disappear", they are not deleted from the table but in the record selector there are GONE.

HELP...

[cyberdwarf]

Gilberto

Make sure that AllowAdditions/AllowDeletions/AllowEdits are set to YES, then try again.

The DataEntry property allows ONLY new records (that's why you can't see existing records if DataEntry=Yes)

HTH Steve

[missinglinq]

This is somewhat curious, because the code should work unless, as Cyberdwarf suggested, AllowAdditions were set to No! The curious part is that if AllowAdditions were set to No, the code should cause a "Cannot go to record" error to occur.

Linq ;0)>

[Gilberto]

Hello again,

I tried again with DATA ENTRY=YES and i think it IS working. Every time i open the form it lines will be clear and i can enter NEW information. The problem now is that i CANT go/edit previous record which i NEED to do.

Just to be clear:
Right now the referred properties are all = YES, except for DATA ENTRY=NO.
Ive been working like this and it works perfectly, as sometimes i have to complete/modify/delete information on previous records. The only thing i want to avoid is that every time i open the form and want to continue entering NEW records (which is much more common that modifying previous ones) i have to go to the last record + 1 so that i can start.

This is NO big deal i was just wondering it there was a simple way to go DIRECTLY to this NEW record BUT also having the possibility to navigate the records i already have.

Thanks again,
Gilberto

[cyberdwarf]

Gilberto

I have just created a small form to do what you want & it worked first time!!!!

AllowEdit/AllowDelete/AllowInsert = Yes; DataEntry = No

OnLoad event includes:-

DoCmd.GoToRecord , , acNewRec

?????

Steve

[Gilberto]

Gilberto

I have just created a small form to do what you want & it worked first time!!!!

AllowEdit/AllowDelete/AllowInsert = Yes; DataEntry = No

OnLoad event includes:-

DoCmd.GoToRecord , , acNewRec

?????

Steve

Thanks Steve, it DOES work now. I had a "me.requery" in the form_load which was creating the problem.

Gilberto

[Gilberto]

[quote=Gilberto]Thanks Steve, it DOES work now. I had a "me.requery" in the form_load which was creating the problem.