run macro with record change

asked 2015-06-05 09:28:47 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Hi: I have a nice running database, but I want a graphic on my form to be Visiblel = True/False depending on the data in a control. I need the macro to run for each record I move to on the form. I can't find an event that will trigger the macro. This seems pretty basic to me, but it has me stumped. Thanks for any help you folks have.

edit retag flag offensive close merge delete



I assume that the control you want to use to set the graphic visibility is linked to a field in your database. Also I am assuming the Form Event "When Loading" only occurs when the Form is initially opened and the Events "Before/After Record Action" only occur when a change is made to record. One option may be to put two buttons on the form to perform Record Navigation rather than use the built in Record Navigation Bar. You could then assign a macro to perform Record Navigation and the graphic.

peterwt gravatar imagepeterwt ( 2015-06-08 12:54:26 +0200 )edit