Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find an invoice (Office 2000)

    Hello,
    In my Orders database, it's taking me more and more time to scroll thru and find an invoice when payment is received. I tried to do a combo box like I did to find Customers, Orders, Due Date etc. but because the Invoices and payments are in a subform/subreport based on another table, it doesn't work.

    Does anyone know how I can put in a combo box so that I can easily find the invoice listed on the subform?

    Thanks!
    Louise

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find an invoice (Office 2000)

    In the row source of the combo box for invoices, you could add the table customers and link them. Add your customer ID field. If the customer field is the second field in the combo, you then could use the same code as in the other combo's but use as search condition something like:
    "[CustomerId] = " & Me![ComboName].Column(1)
    The counts of the columns of a combo begin with 0. Using Column(1), is using the second column.
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Find an invoice (Office 2000)

    Thanks Francois for all your help! Greatly appreciated.

    I learned that I cannot use the Wizards for all things and that I needed to learn how to use the Query or Expression Builder!
    It will take some time but I'm getting there! <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Thanks again!
    Louise

Posting Permissions

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