Results 1 to 4 of 4
  1. #1
    astath is offline Advanced Beginner
    Windows 10 Office 365
    Join Date
    Apr 2020
    Posts
    30

    editable subform with info from other tables

    This is a beginner’s question. I'm trying to create a form with a subform in order to perform data entry. What I would like is the subform to also have some info from other tables. Apparently in order for access to do that it changes the controlsource of the subform from a field of the subform table to a query. When doing so though I can't perform the data entry needed.

    i.e. I have the table multicase and the subtable multicaseitems. The form multicase has a field that I can use to type a multicase ID and with the subform I want to add Case IDs (combobox with row source from the cases table). So far so good. If I use “add existing fields” to add fields from different tables like casedate that comes from a different table, they can’t be added. If I switch to design view of the subfrom and do the same I can add them but the subform wont add rows. key fact is that I dont need to update the values of the other tables, it's just to be viewed.

    Is there any way to tackle this?

    thanks!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Why would a ControlSource be changed to a query? That really does not make sense.

    Which table do you want to view data from - lookup table that is RowSource of combobox? Include fields in combobox RowSource. Use expression in textbox to reference combobox column index. Index begins with 0 so column 2 is index 1:

    =[comboboxname].Column(1)

    Set textbox TabStop No, Locked Yes.
    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.

  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
    Or you could use dlookups on the subform to show the other data.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Yes, DLookup() can do the same but I have known it to perform slowly on form when navigating records.
    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. Editable textbox to update subform
    By fhickler in forum Access
    Replies: 8
    Last Post: 06-25-2019, 02:52 PM
  2. Replies: 8
    Last Post: 11-16-2014, 04:22 PM
  3. Replies: 5
    Last Post: 07-15-2014, 09:56 PM
  4. Unbound Form and Editable Subform
    By tndinnc in forum Forms
    Replies: 6
    Last Post: 04-19-2013, 05:42 PM
  5. Updatable & editable subform?
    By jfn15 in forum Forms
    Replies: 2
    Last Post: 06-21-2011, 10:35 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