Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003

    Unhappy Unanswered: Help with Lookup

    I hope this is an easy fix, but it is perplexing me..

    On an add record form for placing an order, I want the user to be be able to search for a customer by name or customer number and have that information on the customer filled in automatically and then they complete the order form. This works perfect for the customer by name, however, the cust. id, it will not work.. The cust ID is an autonumber and I am wondering if that is the problem..

    Any help would be appreciated..

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    doubtful. What method are you using?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jun 2004
    hi, they are of different data type (text and long), something is missing in your search statement??

    text search you say something like [name] = "My Name"
    numeric search, you have to say something like [id] = 1234


Posting Permissions

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