Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo Box Auto Expand (Access 2000)

    There is a combo box on a subform whose control source is an simple SQL statement where the bound field is the key of the query's underlying table. Nothing complicated at all. Properties Auto Expand =Yes, Limit to List = Yes. It does fills in the combo box from the list with the first value matching the first character that is typed.

    However, as additional characters are typed, it does not change the value displayed to match all the characters typed. It treats every character typed as the first. So if Pr is typed, it navigates to the P entries and then immediately navigates to the R entries, not the Pr entries.

    Does anyone have an insight into this problem?

    Thank you.
    Thomas W

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box Auto Expand (Access 2000)

    Do you have any event procedures for the combo box and if so, what are they?
    Do you have an On Timer event procedure for the form or subform?

  3. #3
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box Auto Expand (Access 2000)

    I have an OnChange Event that populates other fields on the subform dependent on the combo box entry.
    This use to perform properly, but maybe I should attach that code to another event for the combo box? Which one would you recommend?
    There is not an OnTimer Event for the subform or parent form.

    Thanks for your reply, Hans.
    Thomas W

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Combo Box Auto Expand (Access 2000)

    You could try the After Update event instead of the On Change event to see if it works better.

    If not, could you post a stripped down copy of your database? See <post#=401925>post 401925</post#> for instructions.

  5. #5
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    USA
    Posts
    379
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo Box Auto Expand (Access 2000)

    Thank you so much, Hans - this worked like a charm.

    ThomasW

Posting Permissions

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