Results 1 to 2 of 2
  1. #1
    dougie is offline Novice
    Windows XP Access 2007
    Join Date
    Dec 2011
    Posts
    27

    Combo box not populating in DataEntry mode

    I have two forms, each containing a combo box whose values come from tables other than the one the form links to. I find that if data entry mode is No, both combo boxes populate correctly. If I set Data Entry to Yes on both forms, the combo box on one does not populate, but the other is still OK. I can find no difference between the forms to explain this. I'm using Access 2007.



    Update: it seems to be a bug that arises when you hide a column on a datasheet form. I have four columns. Hiding one does no harm, but hiding another causes the combo box to fail to populate, whether or not in Data Entry mode. Unhiding a column does not fix the problem - the form is now corrupt and must be deleted and re-created.

    Update2: the corruption can be undone by switching to single form view then back to Datasheet view.
    Last edited by dougie; 01-20-2012 at 05:32 AM. Reason: Update

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Issue is resolved?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Combo box requery issue in tabbed form mode
    By michael0610 in forum Access
    Replies: 9
    Last Post: 11-17-2011, 03:22 PM
  2. Replies: 2
    Last Post: 09-01-2011, 10:48 PM
  3. Replies: 4
    Last Post: 01-14-2011, 10:37 AM
  4. COMBO BOX Populating
    By b123 in forum Forms
    Replies: 14
    Last Post: 10-13-2010, 03:34 PM
  5. Populating other fields from combo box.
    By nkenney in forum Forms
    Replies: 1
    Last Post: 05-14-2009, 10:39 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