Trying to return value on multiple selections

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Here is the situation:
I am open to any suggestions to change anything. Thank-you.
I have a list of exemptions that the taxpayer could qualify for. I need to be able to choose more than one for each taxpayer. Then once the exemptions are selected I need the value of each selected exemption to show up in the Total Exemption Box on the form. I don’t know whether to use a list box, combo box, or option buttons for choosing the exemption. I know that if I use a multi-selection box that the value of each is hard to work with. So I thought I would go with option buttons. But I need to allow the user to add exemptions if they need to. Help!!
 
Hi,

It doesn't seem like you've told the whole story. Maybe you haven't thought
through your design??

What comes to my mind is that the list of possible exemptions would exist in
a table, just a normal table called a lookup table because that's how we'll
use it. tblPossExempt. That table should have associated fixed amounts
where that applies and a description of what that exemption is.

I assume that when you use these exemptions you might retrieve one to the
current form and put its name and singular value in textboxes. On that same
form there should be a textbox txtMultiplier which by default would be 1 but
that could be some larger value. There should also be an extension value
which can be summed over the whole record and displayed on the form (not
saved in the record). For the user initiated exemptions there should be an
"Other" description in your lookup table. Choosing Other should create an
entry with Other in the name box, no value entered, multiplier of 1, etc.
Replace "Other" with the name/brief description of the exemption.

If that's how it works then I'd recommend using a combobox on a subform.
You can have a large number of columns in a combobox and you can use its
AfterUpdate event to write its retrieved values to appropriate textboxes.

HTH
--
-Larry-
--

Osuchjoy said:
Here is the situation:
I am open to any suggestions to change anything. Thank-you.
I have a list of exemptions that the taxpayer could qualify for. I need
Click to expand...
to be able to choose more than one for each taxpayer. Then once the
exemptions are selected I need the value of each selected exemption to show
up in the Total Exemption Box on the form. I don't know whether to use a
list box, combo box, or option buttons for choosing the exemption. I know
that if I use a multi-selection box that the value of each is hard to work
with. So I thought I would go with option buttons. But I need to allow the
user to add exemptions if they need to. Help!!
 
It needs to be a bit more complex than "a Table and a Query". From what you
described, I think you need at least 3 related Tables:

* tblTaxPayers
* tblExemptionTypes (more or less a "Look-Up" Table)
* tblTaxPayerExceptions

Each of your Table should only store data related to ONE entity in your
database. Perhaps, you need to check out the Relational Database Design
Theory and the Database Normalisation technique and apply them to your
database first.

Once you have the Table Structure properly designed and implemented, the GUI
should generally follow logically.

--
HTH
Van T. Dinh
MVP (Access)


Osuchjoy said:
OK I have been working on this for days. I have the table. I have the
Click to expand...
query. I see what you are saying, but how do I get multiple selections in a
combo box then retrieve the sum of each selection to one box?? I originally
had the combo set up and it retrieved the value from the query, but I need
to be able to select more than one exemption (example: Homestead and
Veterans) I had them together Homestead/Veterans and that doesnt work
because I need them to show up on separate reports not the same one. Thanks
for your help..JOY (e-mail address removed)
 
Hi Joy,

My assumption is/was that a subform would be used and would link the
exemptions to the parent record. In my concept:

The combobox is on the subform. Once you make your first selection your
subform will generate a new, empty record. Fill in names, amounts,
multiplier description as required. You make a selection on the new record
and do it all again. You get a single selection per combobox but lots of
comboboxes. You can keep the sum of exemptions up to date using DSum() on
the extended exemption values.

I assume that tblExemptions records are related to the record based on the
entity whose tax return this is. I suggest enforcing Referential Integrity
and enable cascading deletes.

HTH
--
-Larry-
--

Osuchjoy said:
OK I have been working on this for days. I have the table. I have the
Click to expand...
query. I see what you are saying, but how do I get multiple selections in a
combo box then retrieve the sum of each selection to one box?? I originally
had the combo set up and it retrieved the value from the query, but I need
to be able to select more than one exemption (example: Homestead and
Veterans) I had them together Homestead/Veterans and that doesnt work
because I need them to show up on separate reports not the same one. Thanks
for your help..JOY (e-mail address removed)
 
You're welcome. Glad to help.

Did you notice that Van came in with an identical suggested entity and
lookup structure?
 
Back
Top