Results 1 to 6 of 6
  1. #1
    koturtle is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    7

    Subform doesn't populate until after going into Design View

    I have a subform that is blank.



    As soon as I go into design view and then back into form view the data shows asexpected.

    My allowadditions is set to yes.

    any ideas?



  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,527
    make sure DATA ENTRY =no, so it wont show 'empty' for data entry.
    Make sure to remove the FILTER
    set FILTER ON LOAD = no

    make sure you bound the subform to the master form via
    LINK MASTER FIELDS,
    LINK CHILD FIELS

  3. #3
    koturtle is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    7
    Quote Originally Posted by ranman256 View Post
    make sure DATA ENTRY =no, so it wont show 'empty' for data entry.
    Make sure to remove the FILTER
    set FILTER ON LOAD = no

    make sure you bound the subform to the master form via
    LINK MASTER FIELDS,
    LINK CHILD FIELS

    Didn't help, thanks

  4. #4
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,655
    Make a copy of your DB and strip out whats not needed. Leave enough data for form to work and post the copy.

  5. #5
    koturtle is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Posts
    7
    Quote Originally Posted by moke123 View Post
    Make a copy of your DB and strip out whats not needed. Leave enough data for form to work and post the copy.
    uploaded,

    the subform on the top right where it says Costed BOM is the one that isn't showing.
    thank you
    Attached Files Attached Files

  6. #6
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,655
    There is an error in the textbox -LinkTop- which you are trying to use as Master/child link.
    The value of the textbox is reliant on the subform which is reliant on the combobox.
    Subforms load before the mainform.

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

Similar Threads

  1. Replies: 10
    Last Post: 02-06-2018, 02:37 PM
  2. Replies: 4
    Last Post: 04-09-2015, 07:52 PM
  3. Replies: 6
    Last Post: 05-09-2014, 09:03 AM
  4. Replies: 5
    Last Post: 12-03-2013, 01:25 PM
  5. Replies: 2
    Last Post: 12-30-2011, 07:19 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