run macro with record change [closed]

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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-21 22:04:02.352216

Comments

1

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