Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    56

    Red face Unanswered: odd question populating combo boxes using a filtered form

    Hi all,

    I have searched the web and this site and I was hoping someone could give advice on the following:

    I am trying to populate a combo box with the filtered records from a form. The form in question has been filtered using a parameter query.

    Is there any easy way of doing this?

    Any suggestions would be very much appreciated!

    Thanks for reading,

    coolowen.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Assign the same query to the combo box?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Jan 2003
    Posts
    56
    Quote Originally Posted by Teddy
    Assign the same query to the combo box?

    I can do that but the problem is that it is a parameter query so two parameter boxes appear for input if I try to use the combo box.

    Any ideas?!!

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    refine your query so thats its pullingthe parameters from a control(s) on a form

    parameter can be pulled in as
    <mycolumn>=!forms!<myformname>!<mycontrolname>

Posting Permissions

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