InteractX and VBA

I am new to VBA and am trying to write some code that will monitor a bit from a SLC500 into InteractX V2.51.

I am sending PLC batch data to an Access database through the VB editor using SQL commands in InteractX. I am able to store data in the Access database, I can also print this data to a printer via a push button on the HMI screen. I would like to print the PLC data using a trigger bit from the PLC. I don't know what the VBA code should look like.

I know I have to compare to Tags.TagName.Value = 1, but what kind of function or subroutine do I use?

Thank you,

Robert

A couple of thoughts. I am not at my work computer, so I can't access InteractX at the moment.

Add the PLC bit as an OR condition to the print routine you have now.
Add another button on your screen that is activated by the PLC bit. Build code from this button. You can make this button invisible to the operator.

Also, don't hesitate to contact CTC. They have always been helpful when I needed them.