Change in Record

[Guest]

What event would I need to create in a form to update rectangles, lines, etc
when a user moves from one record to another.

For example, my form has a rectangle that changes based upon the information
inputed in the form. I need the rectangle to change as the users views the
next record? I can get the rectangle to change on edit when the input
parameters are reselected...but not on views?

 

[John Nurick]

Hi Heiko,

The Current event fires when the form is about to display a record.

 

[Larry Linson]

"Heiko K Stugg" wrote

What event would I need to create in a
form to update rectangles, lines, etc
when a user moves from one record to another.

For example, my form has a rectangle that
changes based upon the information
inputed in the form. I need the rectangle to
change as the users views the next record?
I can get the rectangle to change on edit when
the input parameters are reselected...but not
on views?

Put the code to change the rectangle in the OnCurrent event, and it will
execute whenever a different record is displayed. If the changes also
should be made when some other Control on the Form is modified, place a call
to the same code to change the rectangle in the AfterUpdate event of that
Control.

Larry Linson
Microsoft Access MVP