Results 1 to 3 of 3
  1. #1
    johnnyflames is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Michigan
    Posts
    6

    Sub Form not populating from Combo Box on Main Form

    Hello Everyone,
    I'm learning day to day. I inherited a customer database from 2000. Yup, 2000.
    It works fine in Access 2003 and 2007. But as soon as I start it in Access 2010, the problems begin.
    The latest is this.


    I have a form that has a combo box with customer IDs filled from a table.
    Click image for larger version. 

Name:	form1.jpg 
Views:	4 
Size:	21.9 KB 
ID:	8076
    When you click the arrow pointing to the right, it opens another form.
    Click image for larger version. 

Name:	form2.jpg 
Views:	2 
Size:	59.5 KB 
ID:	8077
    When this form opens, the combo box you see is NOT visible. I'm showing it to debug.
    The sub form that is visible, should be populated with data from a table based on the customer ID.
    For example, the results in Access 2007, below.

    Click image for larger version. 

Name:	form3.jpg 
Views:	2 
Size:	46.2 KB 
ID:	8079

    In Access 2010, the sub form does not populate.


    John
    Attached Thumbnails Attached Thumbnails form3.jpg  

  2. #2
    johnnyflames is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jun 2012
    Location
    Michigan
    Posts
    6
    Solved it myself.

  3. #3
    aroque is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    8

    Thanks

    Quote Originally Posted by johnnyflames View Post
    Solved it myself.
    Thanks,
    you could have at least posted what you did to fix it so someone having the same problem could read it

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

Similar Threads

  1. Replies: 12
    Last Post: 01-18-2012, 10:02 AM
  2. Replies: 3
    Last Post: 04-04-2011, 02:45 PM
  3. Replies: 5
    Last Post: 01-02-2011, 10:09 AM
  4. Replies: 6
    Last Post: 01-13-2010, 02:41 PM
  5. Replies: 0
    Last Post: 08-17-2008, 12: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