Results 1 to 5 of 5
  1. #1
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151

    Problems with combo box in subform

    I am having trouble with the 3rd subform, which has a combo box.

    Main form: Request Information
    Sub form: RequestPlus Corrections subform
    Combo box: Opens, displays correct values, doesn't allow me to pick a value.



    Database attached

    It's probably something basic I'm overlooking - I just can't see it. Thanks in advance!!
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    The combobox is bound to wrong field. Should be CorrectionTypeID in the ControlSource.
    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.

  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
    June7 has supplied the fix; the reason you couldn't make a selection, when the Combobox was Bound to the CorrectionId field in CorrectionsRequested Table, was because CorrectionId, in that Table, was defined as an Autonumber Field, and only Access, itself, can supply the data for an Autonumber Field.

    Linq ;0)>

  4. #4
    msmithtlh is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    151
    Thank you both!!

  5. #5
    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
    Glad we could help!

    Good luck with your project!

    Linq ;0)>

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

Similar Threads

  1. Problems with Subform displaying records
    By Astron2012 in forum Forms
    Replies: 2
    Last Post: 09-07-2012, 05:56 AM
  2. Subform / Main Form problems...
    By aceoftrades in forum Forms
    Replies: 4
    Last Post: 03-18-2012, 10:39 AM
  3. combo box problems
    By metokushika in forum Access
    Replies: 2
    Last Post: 11-09-2011, 03:01 AM
  4. Problems with Subform on TabControl
    By Bob Newingham in forum Forms
    Replies: 9
    Last Post: 03-28-2011, 10:24 AM
  5. Problems with subform refresh
    By Viggen66 in forum Queries
    Replies: 2
    Last Post: 02-23-2010, 04:07 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