By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Form_Load similar for recordset?

P: 2
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.
Sep 2 '07 #1
Share this Question
Share on Google+
3 Replies


FishVal
Expert 2.5K+
P: 2,653
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.
Sep 2 '07 #2

P: 2
*****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
Sep 4 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
*****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 ....

Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_Current()
  2.     MsgBox "current"
  3. End Sub
  4.  
Don't put brackets around the message as that indicates you want a value returned.
Sep 5 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.