Results 1 to 4 of 4
  1. #1
    Beginner72 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Dec 2016
    Posts
    12

    Question Combo box in a form is changing the first value in the linked table


    Hello, everyone. I am new to this forum and newer to Access. I have created a form that uses a combo box to select a record from a linked table. In this case I am selecting a Vendor from a Vendors table. Once the vendor is selected I use a macro (via a button) to open another form in a datasheet view filtered by a query. When the vendor list is shown from the Vendors table it is sorted alphabetically. However, every time I select a vendor and exit the form (whether I run the macro or not) it overwrites the vendor name of the first sorted record of the vendors table with the Vendor ID number of the Vendor selected. Does anybody have any thoughts on what is causing this? The Vendors table is simple and has two fields, a vendors ID and Vendors Name.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    The combo is bound to the field (has a control source). For searching, it should be unbound (no control source).
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Beginner72 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Dec 2016
    Posts
    12
    Thank you so much. Worked perfectly.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Happy to help, and welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 1
    Last Post: 09-23-2014, 08:56 AM
  2. Replies: 22
    Last Post: 05-10-2014, 04:43 PM
  3. Replies: 2
    Last Post: 04-15-2014, 10:03 PM
  4. Changing ODBC Linked Table Stored Credentials
    By JeffGeorge in forum Access
    Replies: 1
    Last Post: 08-09-2013, 01:53 PM
  5. Access form combo box value changing
    By justrizlee in forum Forms
    Replies: 1
    Last Post: 12-22-2010, 08:56 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