Results 1 to 4 of 4
  1. #1
    richard1941 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    10

    Combo box corrupting underlying table


    I have a combo box for selecting records in a table. When I do, the underlying table is corrupted in that the entry selected replaces the first entry in the table. Anybody know why or how to prevent this?

    Thanks,
    Richard

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    My guess is that the Combobox has a Field in its Control Source Property, which means that it is Bound to a Field in the underlying Table. For doing this kind of thing, the Combobox has to be Unbound! Go to Properties - Data, for the Combobox, and delete the Field from the Control Source Property.

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

    All posts/responses based on Access 2003/2007

  3. #3
    richard1941 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2014
    Posts
    10
    You are exactly right. I had solved that problem somewhere else and forgot about it.

    Thanks much.

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    You're quite welcome! It's a common problem, which is how I knew what you'd done! And, of course, you're more likely to remember the solution the next time around!

    Good luck with your project!

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

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 4
    Last Post: 11-25-2014, 11:23 AM
  2. Replies: 12
    Last Post: 11-11-2014, 02:10 PM
  3. Replies: 4
    Last Post: 12-01-2013, 07:34 PM
  4. Form not updating underlying table
    By Kirsti in forum Forms
    Replies: 8
    Last Post: 02-10-2012, 12:23 AM
  5. Replies: 7
    Last Post: 01-08-2012, 06:20 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