Form not setting acrecnew (1 Viewer)

[swell]

Hi,
The following code works (waiting for a new record entry) when I enter it into the code window then change the form from design view to form view.
But if I close the form and then re-open, it fails and just shows the last entry (or record).

The form has a sub form showing the contents of the table.
The code sets focus to the sub form in an on Load event and selects the last record.
The main form also shows the last record in the dataset.
What is required is that the main form be ready for the entry of a new record.
I have trolled the net to find a solution.

Private Sub Form_Open(Cancel As Integer)

'DoCmd.GoToRecord acDataForm, "Member Activity Entry", acNewRec
   Me.SetFocus
   DoCmd.GoToRecord , , acNewRec
' I tried same result
'  DoCmd.GoToRecord acForm, Me.name, acNewRec
'
End Sub

 

[arnelgp]

move your code to the Form's Load event

 

[isladogs]

I have trolled the net to find a solution.

Sorry to go off topic but your misspelling of 'trawling' the net did make me laugh.
Oh and I agree with arnelgp on how to fix your issue

 

[swell]

isladogs

Sorry to go off topic but your misspelling of 'trawling' the net did make me laugh.
Oh and I agree with arnelgp on how to fix your issue

Felt as dumb as a Troll else I would have just trawled

arnelgp

move your code to the Form's Load event

I had originally had it in there, I just reinserted into the onload event.
Now it doesn't go to acNewRec when I close the VBA code window just shows the first record.
Also closing and opening the form gives same result.

 

[arnelgp]

did you put it on the Main Form's Load event?

 

[Dreamweaver]

Can't you set the forms data entry to yes that way a new record is displayed

 

[swell]

did you put it on the Main Form's Load event?

Yes that's where I put it.

 

[swell]

Can't you set the forms data entry to yes that way a new record is displayed

Mick that fixed the problem thank you!

 

[Dreamweaver]

No Problem glad to help

mick

 

[missinglinq]

Mick that fixed the problem thank you!

Just be aware that by doing this, you can only enter new Records...you cannot view/edit previously existing Records.

Linq ;0)>