Results 1 to 4 of 4
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Combo box not selecting (Access 2003 SP2)

    I am trying to setup a search feature which will given a fieldname (via combo box) and value (via a text box) takes these values to build the Filter string for the form.

    I have a combobox on a bound form that looks up fieldnames. The combo box is not bound to the query behind the form, it draws it's entries.from a Fieldname table.

    When i select an entry (when the combobox arrow is clicked) it doesn't populate the combobox. It just leaves the highlighted entry in the list highlighted.

    Hope i'm not being too vague here.

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Combo box not selecting (Access 2003 SP2)

    I think i have found the problem, the form has AllowEdits set to No.

    Seems like i will have to set all fields in the form to Not Enabled and Locked .

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

    Re: Combo box not selecting (Access 2003 SP2)

    Except for the combo box, of course!

    (If you set Allow Edits to No, all controls on the form are locked, even unbound ones.)

  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Combo box not selecting (Access 2003 SP2)

    Of course.

    All solved thanks.

Posting Permissions

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