OnLoad -versus- OnOpen (1 Viewer)

[ojukiyo]

Hello From Spain...
That's my first post.
Sorry if my english is not enough good ....

Initially these lines of code were in the OnLoad event of a ContinuousForm type form.
Due to needs, when modifying the form to DataSheet, that code started giving error.
I have solved it by placing the code it into Form_Open .... But a dont understand why

Code ...
'Si existen registros, ir al último registro
If Not Me.Recordset.BOF Then
DoCmd.GoToRecord acDataForm, Me.Name, acLast ' ...... (?) error tras convertir el formulario continuo al tipo hoja de datos
End If

 

[GinaWhipp]

Hmm...
On_Open occurs when an instance of the Form is instantiated as an Object.

On_Load occurs when the Record Source for the now opened Form, is loaded into the Form.

 

[GinaWhipp]

Oops, welcome to the Forum!