Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2012
    Posts
    4

    Red face Unanswered: Unbound Combo box navigation doesn't reflect record display

    I created an unbound combo box to allow users to easily navigate among records in form view. I made the combo box nice and big to encourage use. And it works great in trials.

    However, if a user should move to another record by means other than the combo box -- like searching a text field-- the form view switches to another record, but the combo box doesn't respond. It continues to show the ID for the last record navigated to, which could easily fool a user. Yikes!

    Any way to make the combo box navigation box respond to record changes? Or at least be blank?
    Last edited by Cynthiac; 03-30-12 at 18:39. Reason: clarity

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    To blank out the Combobox when moving to a Record:
    Code:
    Private Sub Form_Current()
       Me.ComboboxName = Null
    End Sub
    To set the Combobox to reflect the Current Record:
    Code:
    Private Sub Form_Current()
       Me.ComboboxName = Me.BoundFieldName
    End Sub
    where BoundFieldName is the name of the Control in your Record that displays the same data as is displayed in the Combobox.

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Mar 2012
    Posts
    4
    I chose the second option -- to have the combo and current record match. Worked perfectly! Thanks for your help.

  4. #4
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad we could help!

    Good luck with your project!

    Linq ;0)>
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •