Hi,

I have a report which has test reports waiting to be sent to clients, however, I have a problem. I have a condition on a custom send button which checks their account status. It's either Operational or On Hold. If it's operational the send button works, as expected.

The pulling of this data requires the form to be opened to trigger the "On Load" event which checks the account status. How can I go about this without going into each record, like from the report list? Is there a way to get the latest status for all records in the report on load of that report?

I have it working perfectly via fetch data on the form... I have applied a filter to the report, however, I don't have access to that form directly due to the relationship setup.

Clients (Finance status)

Group (I can pull the data here from above which will then be available in Samples, however, if requires a form load)

Samples (I need to check here)

I'm sure this is me overthinking it, perhaps?

Many thanks