Results 1 to 2 of 2
  1. #1
    Epidural is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    15

    Question Error 3070 When Navigating to a Record

    I'm trying to navigate to a record based on a series of combo boxes and a button. The user goes through the combo boxes, first picking a (let's say) Store, then Aisle, then Item. The Item combo box stores the Item's unique ID as its bound column.



    My code is as follows:
    Code:
    Private Sub NavigateButton_Click()
    Me.Recordset.Clone.FindFirst "[ItemID] = " & Me![ItemComboBox]
    Me.Bookmark = Me.Recordset.Clone.Bookmark '(<-- Don't actually have this in yet, but I will need it)
    End Sub
    The ItemID field in the ItemTable table is an Autonumber Long Integer. Why am I getting the error "Engine does not recognize 'ItemID' as a valid field name or expression"? How do I fix it?

    There are no references within the form to the ItemID directly (no text boxes, hidden fields etc).

    Thanks for any input!

  2. #2
    Epidural is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    May 2012
    Posts
    15
    Quote Originally Posted by Epidural View Post
    There are no references within the form to the ItemID directly (no text boxes, hidden fields etc).
    And therein lied the problem. For anybody else searching for this, it was because the form needs the ID field directly to search for the ItemID from the combo box. I needed to include the ItemID in the Form's RecordSource. Because I did not have any ID fields, it never automatically entered it into its RecordSource. Added it manually and off it goes!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Navigating Datasheet and Combo Box
    By EddieN1 in forum Forms
    Replies: 1
    Last Post: 11-12-2011, 01:07 AM
  2. Navigating from Form to SubForm
    By Gryphen957 in forum Forms
    Replies: 1
    Last Post: 11-19-2010, 10:08 AM
  3. No navigating through records??
    By cvansickle in forum Forms
    Replies: 2
    Last Post: 10-27-2010, 04:05 PM
  4. Help record navigating in forms
    By edo in forum Forms
    Replies: 0
    Last Post: 08-12-2008, 10:45 AM
  5. Treeview Control: Nodeclick --> Navigating to Record
    By greekandromancoins in forum Programming
    Replies: 0
    Last Post: 02-10-2006, 10:29 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums