Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Location
    Middletown, NJ
    Posts
    9

    Multiple Fields In One Combo Box.

    Hi, all can someone help me with a problem .
    I have a table call customer with 3 fields ( fname – mname – lname ).

    I also have a table called invoice and I would like to use a combo box to look up
    In the customer tables And get all 3 of the above fields at one time, is this possible.

    I try to use customer[fname]&” “&[lname]&” “&[mname]
    Not Working.
    What am I doing wrong…


    John.C

  2. #2
    Join Date
    Feb 2009
    Posts
    14
    I think you should try getting the data via SQL query.
    something like this....

    ' THIS POPULATES COMBO FROM TABLE
    combo.SourceType = Table/Query

    Dim sSQL as String
    sSQL = "SELECT fname, mname, lname FROM customer;"
    combo.RecordSource = sSQL
    combo.Requery'

    WHAT CUSTOMER DATA IS STORED IN THE INVOICE TABL;E?

    DO YOU HAVE A CUSTOMER ID?

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

Similar Threads

  1. multiple fields in separate records
    By Fredo0709 in forum Database Design
    Replies: 9
    Last Post: 04-09-2010, 12:23 PM
  2. Combo box select from two fields
    By cnestg8r in forum Access
    Replies: 0
    Last Post: 10-31-2008, 10:05 AM
  3. Replies: 0
    Last Post: 08-17-2008, 12:19 PM
  4. Replies: 0
    Last Post: 12-19-2006, 09:44 PM
  5. One table multiple fields identical properties.
    By swampdonkey in forum Queries
    Replies: 2
    Last Post: 09-29-2006, 10:53 AM

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