VBasic reference of record stepping

[xxyy]

Hi All!

I d'like to ask for your help in the following issue:

When I step the records on a form clicking on the arrows below I want refresh some field reacting on this event.

How can I refer to this event in Visual Basic? And how can I bind the VB program to the form? (Because - as I know - there's no field on the properties box for this purpose)

(Or if you know an event equivalent to this record stepping, I think it would do as well)

Thanks in advance.

BR

xxyy

 

[Rich]

Use the FormCurrent event

 

[MStef]

It is "On Current" event.

 

[Rich]

Private Sub Form_Current()

 

[xxyy]

Guys,

Thank for your help, but I guess I did something wrong because it didn't work...maybe I bound the event to the wrong element?

I typed in TOOLS>MACROS>VISUAL BASIC EDITOR the followings (with the relevant names), but I guess I did something wrong because it didn't work...

My test:

Private Sub FormCurrent()
Forms![FormName]![FieldName].Requery
End Sub

Private Sub OnCurrent()
Forms![FormName]![FieldName].Requery
End Sub

Private Sub FormName_FormCurrent()
Forms![FormName]![FieldName].Requery
End Sub

Private Sub FormName_OnCurrent()
Forms![FormName]![FieldName].Requery
End Sub

 

[xxyy]

Yes, it succeeded.

Rich's suggetion: Private Sub Form_Current() works.

I tried with 'FormName_Current()', and 'FormName' seems to be wrong.

MStef, Rich: THANK YOU !!!