Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    636
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combo won't requery (2003 SP2)

    In an unbound form, I have an unbound combo box (cboHelps1) whose row source query
    Regards,
    Peter

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

    Re: Combo won't requery (2003 SP2)

    Try setting the row source of cboHelps1 to the SQL string itself, and requery it after changing the row source.

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Patterson Lakes, Melbourne, Victoria, Australia
    Posts
    636
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combo won't requery (2003 SP2)

    It works!. But that begs the question as to why the combo wouldn't requery.
    All I can say is:-
    Attached Images Attached Images
    Regards,
    Peter

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

    Re: Combo won't requery (2003 SP2)

    Changing the SQL of a stored query is done using DAO (I assume), this operates at a lower level than Access, so Access doesn't "know" that the query has changed.

Posting Permissions

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