Perry,

upon further review your hint was very helpful. There was a second query in the report I was missing. This was the probem when linking to the SQL server....

Russel-

I tried implementing the following code (as your link indicated):

Private Sub Report_Error(DataErr As Integer, Response As Integer)

    Dim sError As String

    Dim nI As Integer

    Dim sTitle As String

    sError...

I'll give that a shot. Thanks for the help. I've also been told it may have to do with how the update queries are working in Access so I'll take...