Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2011
    Posts
    3

    Unanswered: Navigation Form help in access 2010

    I currently have a form (customer orders 3 ) that automatically fills in 2 boxes in a form. When I try to use a navigation form with ths form I receive an error stating the form (customer orders 3) cannot be found. Below is the current code. Thanks for any Help

    Me.Customer_First__Name = DLookup(" [Customers]![Customer First Name]", "Customers", " [Phone Numbers]=""" & [Forms]![Enter Orders 3]![Phone Numbers] & """")

    Me.Customer_Last__Name = DLookup(" [Customers]![Customer Last Name]", "Customers", " [Phone Numbers]=""" & [Forms]![Enter Orders 3]![Phone Numbers] & """")

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    You mentioned a form "customer odrder 3".
    But, what about the form "Enter Orders 3" ???
    Also, your DLOOKUP code is wrong.
    Look at Access help about DLookup function,
    (attachment, word, zip).
    Attached Files Attached Files

  3. #3
    Join Date
    Jan 2011
    Posts
    3
    sorry mistyped in the forum i meant enter orders 3

  4. #4
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Send a short example of your mdb, (access 2000 or 2002-2003).

  5. #5
    Join Date
    Jan 2011
    Posts
    3
    Thanks for the reply. The navigation form is new to access 2010. You would need that version to help. My question was answered at another forum.

    Thanks for replying

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •