Combo box choices

  • Thread starter Thread starter Kass W.
  • Start date Start date
K

Kass W.

I have a form with basic patron info. at the top. Then
at the bottom of the form is a combo box with the
choices "Annual Payment" or "Bank Monthly Payment"
or "Payroll Deduction". What I need to do is, if they
choose the Annual Pmt. option, they will not be able to
fill in the Bank Mo. or Payroll Ded. information. If
they choose the Bank Mo. option they won't be able to
fill in the Annual or Payroll Ded. info., etc... Is
there a fairly easy way to do this? Instead of a combo
box, I could also use a radio button option group, if
that would work better, as long as I will be able to
query out each group separately. Thanks for your help!
This newsgroup is awesome! It is easy to use, has tons
of info, and you get speedy responses! Thanks again!

Later!

Kass
 
Do you mean you have a combo box and 3 text boxes and based on the choice
from the combo box you want to enable or disable entering info in the other
2 boxes? A better table desing would be instead of keeping track of 3
entries, keep track of the choice and 1 entry. Then when a choice is made
fro mthe combo box, there is only one entry and you don't need to worry
about the other 2. This design will also make it easier to group out the
choices. If you still want to keep track of 3 entries the way you have now,
let me know.

Kelvin
 
Back
Top