Results 1 to 4 of 4
  1. #1
    james.bland is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    2

    Column in Table randomly changes values in records from a pull-down


    Hi there, new to the forum. I am having a column changing values randomly in a pull-down. The pull-down values are based out of a seperate table. Any assistance is appreciated. Thank you, James

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    The RowSource of your ComboBox should be a query with an OrderBy clause rather than directly to a table.

  3. #3
    james.bland is offline Novice
    Windows XP Access 2007
    Join Date
    Nov 2010
    Posts
    2
    When you say order by, does that mean chosing ascending order in the query?

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    YES! Picking a field to sort on will add an OrderBy clause.

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

Similar Threads

  1. Add & Pull Records from Table via Form
    By sujitshukla in forum Programming
    Replies: 1
    Last Post: 08-02-2010, 05:51 PM
  2. Replies: 1
    Last Post: 08-21-2009, 06:52 AM
  3. Replies: 0
    Last Post: 10-23-2008, 12:08 AM
  4. Replies: 0
    Last Post: 12-19-2006, 09:44 PM
  5. inserting values in column based another column
    By wasim_sono in forum Database Design
    Replies: 1
    Last Post: 06-27-2006, 05:23 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