Print record based on field value.

[MFS]

I posted this question on the Microsoft SQL Server Forum, But will try here as well.


I'm currently working on a new project where a PLC on the plant floor is sending data to a SQL database table.
Data comes into the database whenever the operator finishes a 'run', automatically.

I'm using Access as my front end,
What I'm looking to do is print the row of data the PLC is sending, only if a certain field value is equal to 1. In this case that field is named 'End_Of_Run'
There 24 fields of data that I would like to have printed.

Is there a way access can do this automatically ?
is there another way this could be accomplished otherwise ?

[June7]

Code must be initiated by some event (such as form Open or button Click). If the tables were Access, perhaps with AfterInsert data macro. In SQL Server I think these are called 'Triggers'.