Results 1 to 3 of 3
  1. #1
    Bradex is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    101

    Updating a control after modifying a field

    I had created a Combo box using the values from a table. While setting up with the wizard, I forgot to arrange the entries in ascending order. Now, if I want to do that, what can I do:
    1) Do i have to delete the previous combo box and add a new one?
    2) Is there a way to update the existing combobox?


    3) Is there a way to run the wizard again?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    In the cbo properties, rowsource ,
    click the ellipsis button to edit the query.
    add the sort.

  3. #3
    Bradex is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Sep 2011
    Posts
    101
    Thanks for the solution!

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

Similar Threads

  1. Modifying Form Then Updating ACCDE File
    By Ranger7913 in forum Forms
    Replies: 2
    Last Post: 01-26-2015, 02:55 PM
  2. Replies: 7
    Last Post: 03-02-2014, 08:47 PM
  3. Get value from other control not updating table
    By 1eye1vision in forum Access
    Replies: 3
    Last Post: 02-08-2012, 05:37 PM
  4. Updating Default Value of a Subform Control
    By eww in forum Programming
    Replies: 4
    Last Post: 04-11-2011, 12:57 PM
  5. updating a control
    By Seven in forum Forms
    Replies: 3
    Last Post: 12-20-2009, 09:31 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