Results 1 to 1 of 1
  1. #1
    Join Date
    Jul 2005
    Posts
    144

    Unhappy Unanswered: Combo to display duplicate values in a form

    Hi all,
    I am working on a database for searching parts by typing or using the arrow down key, it seems to work fine for my purpose however it wont show duplicate values.

    In my database I have itemno, Itemname, ItemShelf and ItemDescription fields.
    I have ItemNo which is the part number setup as a combo box so person can search it by partnumber.

    Itemshelf and Itemname are fields with duplicate values since parts are in various different location.

    How can I make it work to where it will show me all of the locations instead of just one???

    I have also tried in the main tbl called tblItems makind my index yes duplicates but that didnt help at all.

    In the form try choosing part number 1253-0703 and you will notice that shelfname and shelf location is same for that part number, where it should have more shelf name and locations.

    I am attaching my Dbase here

    Thanks again
    Attached Files Attached Files

Posting Permissions

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