Results 1 to 3 of 3
  1. #1
    sami1900 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    4

    how to autofill a field in subform based on main form


    I have a field which I want make it takes its value from the main form. For example, I have a field in main form [Saled Quantity] and the same field in subform and I entered 1000 in the main form as value, I want this value shows in the subform directly.

    same Value with one entry in each form

    many Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    use the builder to get the path and object names correct....

    Code:
    sub Saled_Quantity_afterupdate()
      me.subormName.form.txtBox = me.Saled_Quantity
    end sub

  3. #3
    sami1900 is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jun 2016
    Posts
    4
    but when no names here for main form I mean I didn't find the field which I will take the value from it, all things here from subform.

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

Similar Threads

  1. Replies: 2
    Last Post: 05-22-2014, 06:11 PM
  2. Field in the main form based on a subform
    By azhar2006 in forum Forms
    Replies: 4
    Last Post: 03-08-2014, 11:24 PM
  3. Subform - autofill data from main form
    By Kelly_D in forum Access
    Replies: 3
    Last Post: 03-20-2012, 11:36 AM
  4. Replies: 3
    Last Post: 01-18-2012, 03:05 AM
  5. Replies: 2
    Last Post: 08-11-2011, 10:02 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