SalesTax

[GSchafer1]

I'm using a similiar database to Microsoft Orders. On the Orders form I want the default Sales Tax to be 0 unless the customer is from Texas,then 6.75%. I also want to grayout the Sales Tax unless from Texas. I'm using Access97

 

[Travis]

Then what you will need to do is on the AfterUpdate of the field that tells you if they are from Texas or Not have it Set the Tax to the appropriate amount/Enable the Tax Field:

Private Sub fldState_AfterUpdate()
if me.[fldState]="TX" then
me.[fldTax]= .00675 'you can use a lookup to set this outside the code
me.[fldTax].Enabled = True
else
me.[fldTax]=0
me.[fldTax].Enabled = False
end if
end sub