Results 1 to 3 of 3

Thread: Combo Boxes

  1. #1
    Join Date
    Sep 2001
    Posts
    175

    Question Unanswered: Combo Boxes

    Is there a way to filter the results of a combo box? e.g.

    I want Combobox1 to look up the inv. no. in table1 where table1.clientno = combobox6 (combobox6 is the clientno on my form)

    I want the combox to list all the invoices for a particular client.

    Any help would be appreciated.

  2. #2
    Join Date
    Aug 2003
    Location
    Bosnia & Hercegovina
    Posts
    57
    just use Combobox1.RowSource property and put appropriate SQL in it or query name........

  3. #3
    Join Date
    Sep 2001
    Posts
    175
    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
  •