Results 1 to 2 of 2
  1. #1
    bucrepus is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Oct 2015
    Posts
    5

    Multi_valued Field Row Source SYntax

    I have simplified this for display sake.



    I have 2 tables with text fields

    Table 1 has 3 fields and 2 rows

    DEVICE| DISPLAY1 | DISPLAY2
    _______________________________
    A | A1 | A2
    B | B1 | B2


    Table 2 has 2 fields, but the second is a multi-value field

    DEVICE | MDISPLAY
    _____________________________
    A | **MUTI-VALUE** based off the table 1

    In the row source of the Multi-value Field MDISPLAY, I have

    Select DISPLAY1, DISPLAY2 from TABLE1

    The problem. I can get the MDISPLAY field to display the items from Table 1, but it grabs ALL of them.
    I need it to display ONLY the DISPLAY1 and 2 field associated with the value of the DEVICE for the current row in table 2, which is 'A'

    SO if I look at the row of the table 2 that has the device 'A', the MDISPLAY field for that row should have
    Just A1 and A2, NOT A1,A2,B1,B2(all the rows).

    I can't figure out how to access / syntax of the current value of the DEVICE field in my row source..

    Select DISPLAY1, DISPLAY2 from TABLE1 where table1.Device = Table2.device /or Device ... etc.. 'doesn't work


    Any Ideas
    Thanks,
    Buc
    Last edited by bucrepus; 10-23-2015 at 10:15 AM. Reason: Clarify

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    I NEVER use multi-value fields.

    Data structure makes no sense. Why is Display saved in both tables? Why do you have 2 tables with essentially the same data?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 14
    Last Post: 08-20-2015, 03:33 PM
  2. Syntax error in control source of text box
    By shaunacol in forum Forms
    Replies: 7
    Last Post: 07-16-2015, 04:55 AM
  3. Replies: 2
    Last Post: 12-18-2012, 12:43 PM
  4. Replies: 16
    Last Post: 11-18-2010, 11:08 AM
  5. Replies: 11
    Last Post: 04-16-2010, 10:57 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