By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,669 Members | 2,203 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,669 IT Pros & Developers. It's quick & easy.

Error 2105 with Access 2007 -

P: 27
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.SetFocus

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.

Expand|Select|Wrap|Line Numbers
  1.  With Forms!frmMain!frmSKUInput.Form
  2.     !WhichSKUCombo.Value = ""
  3.     !WhichSKUList.Value = ""
  4.     .RecordSource = strSQL1
  5.     .Requery
  6.     !WhichSKUList.RowSource = strSQL2
  7.     !WhichSKUCombo.RowSource = strSQL2
  8.     !WhichSKUList.Requery
  9.     !WhichSKUCombo.Requery
  10.     !ItemNumber.SetFocus
  11. End With 
Jun 24 '10 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.