Results 1 to 9 of 9
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Listbox Suggestion (03)

    I need help with a concept. Think of this as a distribution of payment.

    Example: Someone pays by check for monthly dues. Sometimes they pay the current and/or future months.

    I have a field in a table that uses a listbox to obtain the payment type. In this case it is dues. How would I then distribute an amount for say the current (03) and next month (04)?

    Thanks for your assistance,
    John

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

    Re: Listbox Suggestion (03)

    We'll need much more information:
    - What payment types are available in the list box?
    - Where is the total amount specified?
    - Where are the payments to be stored?

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listbox Suggestion (03)

    Hans,

    I thought about that right after I posted the thread. I have attached a sample file with the various tables.

    I'm open to suggestions,
    John

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

    Re: Listbox Suggestion (03)

    OK, thanks. Now please explain where your original question fits into this.

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listbox Suggestion (03)

    Hans,

    In the receipts table you will find a field named Activity. Look at ID2 with field "activity". You are able to select via a listbox the "Dues". What I would like to be able to do is distribute the $10.00 in the amount field to reflect the due payment for March and April 2006.

    Regards,
    John

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

    Re: Listbox Suggestion (03)

    What you may need is a PaymentsDistribution table that shows for a particular receipt where the distribution goes to.

  7. #7
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Listbox Suggestion (03)

    Pat,

    I concur with you regarding the table but I don't know how to connect the two tables once the dropdown for dues is selected.

    John

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

    Re: Listbox Suggestion (03)

    You cannot do such things through a field in a table. You need a form based on the table, and VBA code that will create and populate the necessary records. I don't do databases with financial transactions, however, so I hope someone else can help you further.

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

    Re: Listbox Suggestion (03)

    What you need is a form (as Hans has said) to input the receipts and a subform to input the distributions against the receipt you have entered. The sum of the distributions should equal the receipt amount.

Posting Permissions

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