I actually reposted the code w/o the important stuff commented out on the first page of this thread, but here it is again, below.

Also, there will indeed be a small...

That code looks great, but still getting

Msg 102, Level 15, State 1, Procedure NoteTypeChange_u_trig, Line 27

Incorrect syntax near '('.

Line is the blank line b/w the '(' and the...

I realize that the entire cursor was commented out on my code so it was confusing. I have posted the code below with better comments to explain what I...

Thanks Gail, but I must get a recordset and choose the the correct record to get the NoteID.

-I have a list of notes on and incident.

-Someone selects a...