Results 1 to 4 of 4
  1. #1
    Paulicus is offline Novice
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    1

    Combo Box Not Showing Newly Entered Data, Combo Box Populate Issues

    I enter data in one form. Then I go to a different form and run a Combo Box control and the data does not show up. I close the database and reopen it and the data is there. I've tried Refresh, Reload, Requery and other obvious choices but am apparently not doing it right - probably putting the command in the wrong place. Any ideas? Thank you in advance. Paulicus Access 2013 and Windows 10

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,726
    Agree --
    probably putting the command in the wrong place
    Please post the related code so readers can see what you are dealing with.

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by Paulicus View Post

    ...I've tried Refresh, Reload, Requery and other obvious choices but am apparently not doing it right...
    Requerying what? If the Form with the Combobox is already open, while you're entering data in the other Form, you need to Requery the Combobox, not the Form.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I enter data in one form. Then I go to a different form and r
    I'm wondering if the data entered in the first form has been saved before going to the second form. All the re-querying in the world won't do any good if the data has not been saved.

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

Similar Threads

  1. Use data in one combo box to populate other
    By BSJoJaMAx4 in forum Access
    Replies: 6
    Last Post: 10-21-2015, 07:56 AM
  2. Data Input Order Form and Combo Box issues
    By Tylerluk1 in forum Access
    Replies: 10
    Last Post: 07-28-2015, 12:46 PM
  3. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  4. Replies: 2
    Last Post: 04-04-2013, 05:56 PM
  5. Replies: 7
    Last Post: 11-13-2012, 01:44 PM

Tags for this Thread

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