Error 2105 with Access 2007 -

**simulationguy** · Jun 24 '10, 09:04 PM

I have a database the runs fine in Access 2003 but this routine crashes with error 2105 "You can't go to the specified record" in Access 2007 on the last line !itemNumber.Set Focus

Any idea why its different in 2007 or if there is a work around? I tried moving the .SetFocus line out of the With statement but same result.

Code:

 With Forms!frmMain!frmSKUInput.Form
    !WhichSKUCombo.Value = ""
    !WhichSKUList.Value = ""
    .RecordSource = strSQL1
    .Requery
    !WhichSKUList.RowSource = strSQL2
    !WhichSKUCombo.RowSource = strSQL2
    !WhichSKUList.Requery
    !WhichSKUCombo.Requery
    !ItemNumber.SetFocus
End With