Search results for query: *

I need to trigger an event whenever a sql database has a new record written to it. Is there a simple method to do this? Running a loop that constantly checks the database isn't an option. Thanks.

I run the loop then when the loop is completed I do a form.show, then return to the loop unless the database has a new record. I've also noticed that buttons on the form don't respond when clicked while the process is running. Is there a better way to update the form?

I'm having a problem with form flicker or with a form not being visible at all during a looping procedure. The procedure constantly checks a database for new records then runs functions whenever the recordset count is not 0. During the loops, the form that displays a listbox of completed...