I have a table that is filled with a lookup (pretty standard there). This completes relatively quickly.

There is then a second lookup that runs a stored procedure. This lookup copies the data from the previously populated table to a SQL table. This slows the form down considerably. Sometimes causes a "Tab is running slow, do you want to kill it" message.

This is the secondary lookup..

Initially, I thought I could just hide (and ignore the values) of the 'EventID' field and hoped that the lookup wouldn't fire until it was shown again.

I'm trying to figure out a way of triggering the second lookup only when the user selects 'Yes' from a dropdown.

Here is the form as it looks now...

If I can't speed up the secondary lookup or trigger it on 'Yes', I need to show a "Data is loading, Please wait message" until the second lookup completes. Any ideas how? I can't work out how to show a Custom HTML message that would be triggered by the secondary lookup (as it doesn't fill in field values)

Any thoughts or suggestions would be appreciated.

I can supply more information if needed too.