Results 1 to 3 of 3
  1. #1
    charly.csh is offline Competent Performer
    Windows 11 Office 365
    Join Date
    Nov 2014
    Posts
    186

    Use data from different tables into the Form

    Hi everyone,

    I have a form named "Main_frm" and the main info comes from a tabled named "Root_tbl" with the field named "root"
    The form has into a field named Roottxt ([Root_tbl]![root])

    I want to add a second field named Root2txt and I want the info comes from a second tabled "Root2_tbl" with a field named "root2"



    (both tables have just one record, I don't really need to be recording more info further but I don't want to create a second form)

    I tried to put into the control source of Root2txt the next statement

    =[Root2_tbl]![root2] but it shows #Name once open the form

    What Do I have to correct?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Add a subform control
    set the subform source to the 2nd table /query/ or form

    set the MASTER FIELD LINK & CHILD FIELD LINK properties to the common fields

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Use a DLookup....
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 7
    Last Post: 07-24-2017, 11:47 PM
  2. Replies: 15
    Last Post: 04-10-2017, 01:09 PM
  3. Replies: 5
    Last Post: 08-12-2013, 12:53 AM
  4. Replies: 1
    Last Post: 07-16-2012, 02:10 PM
  5. Replies: 4
    Last Post: 02-27-2012, 10:29 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