Updating Access Record Via Excel VBA

I currently use a function very similar to this one with a SELECT query to return a field to excel. I have modified this into an UPDATE query to update a field.

I am getting errors at this point:

Code:
If adoRS.BOF And adoRS.EOF Then
DBNoteUpdate = "Value not Found"
Else
DBNoteUpdate = "Action Confirmation"

I believe this area of code was to trap the error that occurs when the lookup field name was not found in the table. I left it in because I still want to trap if the record I am trying to update is not found in the table.

Here is the full code:

Code:
Public Function DBNoteUpdate(RecordNumber As String, _
UpdateTableName As String, _
UpdateNote As String) As Variant
Dim adoRS As ADODB.Recordset
If adoCN Is Nothing Then SetUpConnection

[code].....

The code does work, in that the record is being sucessfully updated by the SQL statement, but its erroring at the point I described above with the error:

Code:
Runtime Error '3704':
Operation is not allowed when the object is closed.

how 'adoRS' is closed at that point because the call to close is right at the end of the function?