Results 1 to 2 of 2
  1. #1
    ChuckJ is offline Novice
    Windows XP Access 2007
    Join Date
    Jul 2013
    Posts
    4

    Combo Box Does not update when using Go To Next Record button

    I have a ComboBox used to select "Sites". Depending on what site, information in other fields within the form change as expected. However, I also added some buttons on the bottom of the form. Go to Next, Previous, Last, etc.



    These update the fields within the form, but do not change the ComboBox field. Is it possible to have a Go to Next record button change a Combobox value? If so, how?

  2. #2
    Dal Jeanis is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Okay, this issue sounds odd.

    First, what is the form bound to? Is it bound to a query?

    Second, what is the combo box bound to? A field in that query?

    Third, what is the code behind the next/previous doing?

    By default, your form can have record selectors/navigation buttons, usually at the bottom of the form's frame. If you are trying to simulate their operation with a larger button somewhere up on the form, and it is not resulting in an automatic movement to the correct record, then you may be accidentally changing the values of the current record, rather than repositioning the form to the next or previous record.

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

Similar Threads

  1. Replies: 13
    Last Post: 12-17-2012, 07:52 PM
  2. Replies: 1
    Last Post: 08-09-2012, 04:19 PM
  3. Replies: 12
    Last Post: 03-14-2012, 10:54 AM
  4. Replies: 16
    Last Post: 06-21-2011, 09:08 AM
  5. Update Record button
    By Steven.Allman in forum Forms
    Replies: 1
    Last Post: 02-16-2011, 02:15 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