Form_Load similar for recordset?

[Alkaline]

As I cycle through records in a form, i want a VB function called for each new record. Does anyone know how this can be done. Greatly appreciated.

[FishVal]

As I cycle through records in a form, i want a VB function called for each new record. Does anyone know how this can be done. Greatly appreciated.

Hi, there.

Look at Form_Current event.

[Alkaline]

*****I fixed it by adding the function using the dropdowns at the top of the window versus copying and pasting the code in.

Original Message:

Thanks.

However, I cant get Form_Current to work. The code in Form_Load work. Here is what I have:

Private Sub Form_Load()
MsgBox ("Exists")
End Sub

Private Sub Form_Current()
MsgBox ("Exists")
End Sub

[MMcCarthy]

*****I fixed it by adding the function using the dropdowns at the top of the window versus copying and pasting the code in.

Original Message:

Thanks.

However, I cant get Form_Current to work. The code in Form_Load work. Here is what I have:

Private Sub Form_Load()
MsgBox ("Exists")
End Sub

Private Sub Form_Current()
MsgBox ("Exists")
End Sub

Try using this instead ....

Private Sub Form_Current()
    MsgBox "current"
End Sub
 

Don't put brackets around the message as that indicates you want a value returned.