Open a trigger (ADP)

Office 2010 support is ending soon

Upgrade to Microsoft 365 to work anywhere from any device and continue to receive support.

Upgrade Now

Note: The information in this topic applies only to a Microsoft Access project (.adp).

You can open a trigger to view or edit the text of an existing trigger that is stored in your database. Triggers are scripted in Transact-SQL for Microsoft SQL Server databases.

  1. In the Database window, click Tables Button image under Objects.

  2. Right-click the name of the table whose trigger you want to open and choose Triggers from the shortcut menu.

  3. In the Triggers for Table: <table name> dialog box, select the trigger you want to open from the Trigger Name list, and then click Edit.

The trigger is opened in the SQL source code editor which you can use to edit the SQL statements. For more information about triggers and the CREATE TRIGGER SQL statement, see the Microsoft SQL Server documentation.

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.