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.
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.