name of event? - Access 2002

[Mondego]

what is the name of the event that occurs when you cycle through the rows of a database whose table is bound to the form.

i tried OnDataChange and OnDataSetChange but those aren't it.

i need to trigger a function to run each time a new row of data displays if the user cycles through the table.

-mondego

[AIS4U]

Mondego:

I bet you can find it here:
http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

[Mondego]

i can't actually. i've been all through those pages.

the best i found was "on change" but here's what i found out about that:

"Setting the value of a control by using a macro or Visual Basic doesn't trigger this event for the control. You must type the data directly into the control, or set the control's Text property."

i'm not changing it "by hand" i'm cycling through the table so it changes by itself. that's why it's not triggering any event when the combobox changes it's value.

[AIS4U]

Mondego:

Well, I guess I don't really understand what you are trying to do since I am not a real VBA guru. Maybe soneone who is will come along with a solution for you.

I do have this site bookmarked in my VBA folder, but I am not sure it will help.

http://www.functionx.com/vbaccess/index.htm

Good Luck

[Siddharth Rout]

These are the only events that you can use

http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx

take your pick...

[RobDog888]

Should be Form_Current.

Access 2007 help file....
http://office.microsoft.com/client/h....DEV&lcid=1033

[Mondego]

excellent!

thanks for the reference koolsid

robdog888, that is exactly what i need.

thanks for your help everyone,

-mondego