quiery for payroll status

[rbutler6]

I am designing a payroll quiery, I have a drop down on the marital status box with single and married. what I need to know is: I would like to if it is possible, when I click on married that my tax bracket will change so that the taxes for married are different from those that are single. and vice versa when I click on single my taxes will change. how can this be done.
hope someone can understand this.

Rose

 

[Galaxiom]

If the tax bracket is dependent entirely on marital status then you should only record the marital status in your table. To record both the status and the bracket is a normalisation conflict.

On your form the tax bracket control should use a control source that takes into account the marital status.

=IIF([maritalstatus], {expression for true}, {expression for false})

If you are only having single and married as marital status change this to a Y/N checkbox field. It uses less storage space and is easier to query. The IIF above assume this.