Open Form to New Record

[transcriptlady]

I am now using Access 2007 and Access 2003 code I had written to open a form
to new record with the ability to see all records is not working. The code
is as follows:
If Not Me.NewRecord Then
RunCommand acCmdRecordsGoToNew
End If

This code is entered in the OnLoad propery of the form. Is the code
different for 2007? Please help.

 

[Allen Browne]

Is any code running in A2007?

It doesn't unless you tell it your database is in a trusted folder via
* Office Button (top left)
* Access Options (bottom of dialog)
* Trust Center (left)
* Trust Center Settings (button)
* Trusted Locations (left)
* Add new location (button)

 

[transcriptlady]

I had changed the security settings prior to posting my question and thought
that the code was not working. However, I have determined that it is working
and is going to a new record. The problem seems to be that the scroll wheel
is not moving to any other record. The buttons at the bottom of the form will
allow me to go to a different record, but I would rather use the scroll
wheel. Any ideas?

 

[Allen Browne]

...The buttons at the bottom of the form will allow me to go to a
different
record, but I would rather use the scroll wheel.

See:
Scroll records with the mouse wheel in Access 2007
at:
http://allenbrowne.com/ser-70.html