[AccessD] Function Error

Two suggestions: 

1. If code can't find the query, do a decompile/compact and repair. In
A2K, I often get a situation where a new query is visible to the user,
but not to code. The decompile/compact fixes that.

2. By rights, this should be a parameter query. 
   * Copy qryInmatesBinNumberUpdate to a new query:
qryInmatesBinNumberForRow
   * Add a RowNo string parameter, and put your external Where clause in
the query
   * Test it
   * Run it with code similar to: 

    Dim oQdf As DAO.QueryDef
    Set oQdf = oDB.QueryDefs("qryInmatesBinNumberForRow")
    With oQdf
        .Parameters("RowNo") = CStr(j)
        Set oRS = .OpenRecordset(dbOpenDynaset)
    End With

Sometimes, restating the problem makes the error jump out. 

-Ken