Results 1 to 2 of 2
  1. #1
    Vanita is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Feb 2019
    Posts
    23

    Allow to copy data from "Subform" to parent form.


    How do i copy data which is displayed in subform(From a query) to paste it in main form(With Table restrictions for "required")

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    normally you dont need to since you already see it in the subform, but
    you can use the full path to the object ...(use the BUILDER to get the path correct)

    me.txtBox1 = me.subform.form.txtBox2

    or use an update query using the key on the master form:
    update [masterTable],subtable set masterTable.[field] = subtable.field where masterTable.Key = forms!myForm!txtKey

    Id use the code version instead of the query.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-14-2017, 05:20 PM
  2. Replies: 13
    Last Post: 12-12-2016, 12:26 AM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. Replies: 9
    Last Post: 08-19-2013, 03:00 PM
  5. Replies: 0
    Last Post: 01-11-2012, 12:34 PM

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