Results 1 to 3 of 3
  1. #1
    libraccess's Avatar
    libraccess is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Napier New Zealand
    Posts
    129

    Combo Box not allowing selection

    I have been going around this for hours
    I have a logon where a staff selects their name it moves to the 2nd cbo (cascades to a region) that they oversee
    but I cannot get anything other than the 1st selection to show after update
    tried all the suggestions I can find (enabled, the query runs OK, locked = no, a new cbo a new form)
    I need a strong coffeeeee

    attached are the bare bones
    if any one can see anything I cannot i will be very grateful

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,626
    Why is the PK in tblRegion called UserID? Wouldn't RegionID be better? Why is the Region combobox named cboUser and label is User? Why is region data field named strUser instead of strRegion?

    Change cboUser RowSource to:
    SELECT tblRegion.UserID, tblRegion.strUser FROM tblRegion WHERE RegionCascadeFK=[StaffName];

    If you want to reference query object instead, must order the fields as shown or set the BoundColumn property to the column with UserID field.
    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
    libraccess's Avatar
    libraccess is offline Competent Performer
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Location
    Napier New Zealand
    Posts
    129
    Solved
    yes I know I should have built the the log on form from the ground up, it was a form with just user and password and I a made so many mods along the way it ended up the way it is.

    Any way I see the error now I had with the bound column.
    I will now go through and rename to make it more logical to understand
    Thanks again for your help

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

Similar Threads

  1. Replies: 3
    Last Post: 12-11-2012, 09:12 AM
  2. Replies: 1
    Last Post: 10-30-2012, 10:29 AM
  3. Replies: 1
    Last Post: 07-11-2012, 08:36 AM
  4. Replies: 33
    Last Post: 01-13-2012, 07:44 AM
  5. Replies: 13
    Last Post: 11-25-2009, 03:10 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