Error 3622

Occurs when selecting combo box of Youth Resiliency & Self Sufficiency Assessment

• The error box shows which function the error is occuring in

• Go to VBA editor for the database and look for that specific function

• When we look inside the function, we see what the error-

  (You must use the dbSeeChanges option with OpenRecordset when accessing a SQL Server table that has an IDENTITY column)

  -above was referencing to:

  

• According to Paul, a Microsoft Access MVP on access-programmers forums, this is the propper syntax for an access database with SQL backend:

  For a recordset:

    Set rs = db.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges)
  

• After fixing the code accordingly, the combo box is working again!