Tax Exemption Case.

[Sohn]

Hi, there,

I am building an invoice form which needs tax exemption case.

The first step I took was adding yes/no data type field to customer table.

Then, I put an invisible textbox named taxcode which bring the yes/no field
value when the invoice form loads by using onload command as follow:

If Me.taxcode = 0 then

Me.tax = 0

End If

The tax field has control source. (=[total]*[taxrate];Currency Format)

When a tax exemption customer loaded, the form gives a run time error, "You
can't assign a value to this object".

Could anyone tell me how to fix this problem? Moreover, is there any better
way to distinguish tax/none tax pay customer otherthan what I have used above?

Thank you.

 

[Duane Hookom]

I would set the control source to:
=[total]*[taxrate] * Abs([YourYesNoFieldName])

 

[Sohn]

Dear Mr.Hookom,

Thank you very much for your help, it works great.

BTW, is there any better way to achieve the same result than using I have?

Thank you

I would set the control source to:
=[total]*[taxrate] * Abs([YourYesNoFieldName])

--
Duane Hookom
Microsoft Access MVP

Hi, there,

I am building an invoice form which needs tax exemption case.

The first step I took was adding yes/no data type field to customer table.

Then, I put an invisible textbox named taxcode which bring the yes/no field
value when the invoice form loads by using onload command as follow:

If Me.taxcode = 0 then

Me.tax = 0

End If

The tax field has control source. (=[total]*[taxrate];Currency Format)

When a tax exemption customer loaded, the form gives a run time error, "You
can't assign a value to this object".

Could anyone tell me how to fix this problem? Moreover, is there any better
way to distinguish tax/none tax pay customer otherthan what I have used above?

Thank you.

 

[Duane Hookom]

I'm not sure what you are asking. Do you want a better method than I
suggested or are you asking why your solution didn't work as expected?
--
Duane Hookom
Microsoft Access MVP

Dear Mr.Hookom,

Thank you very much for your help, it works great.

BTW, is there any better way to achieve the same result than using I have?

Thank you

I would set the control source to:
=[total]*[taxrate] * Abs([YourYesNoFieldName])

--
Duane Hookom
Microsoft Access MVP

Hi, there,

I am building an invoice form which needs tax exemption case.

The first step I took was adding yes/no data type field to customer table.

Then, I put an invisible textbox named taxcode which bring the yes/no field
value when the invoice form loads by using onload command as follow:

If Me.taxcode = 0 then

Me.tax = 0

End If

The tax field has control source. (=[total]*[taxrate];Currency Format)

When a tax exemption customer loaded, the form gives a run time error, "You
can't assign a value to this object".

Could anyone tell me how to fix this problem? Moreover, is there any better
way to distinguish tax/none tax pay customer otherthan what I have used above?

Thank you.

 

[Sohn]

Dear Mr.Hookom,

A better method.

Thank you.

I'm not sure what you are asking. Do you want a better method than I
suggested or are you asking why your solution didn't work as expected?
--
Duane Hookom
Microsoft Access MVP

Dear Mr.Hookom,

Thank you very much for your help, it works great.

BTW, is there any better way to achieve the same result than using I have?

Thank you

I would set the control source to:
=[total]*[taxrate] * Abs([YourYesNoFieldName])

--
Duane Hookom
Microsoft Access MVP


:


Hi, there,

I am building an invoice form which needs tax exemption case.

The first step I took was adding yes/no data type field to customer table.

Then, I put an invisible textbox named taxcode which bring the yes/no field
value when the invoice form loads by using onload command as follow:

If Me.taxcode = 0 then

Me.tax = 0

End If

The tax field has control source. (=[total]*[taxrate];Currency Format)

When a tax exemption customer loaded, the form gives a run time error, "You
can't assign a value to this object".

Could anyone tell me how to fix this problem? Moreover, is there any better
way to distinguish tax/none tax pay customer otherthan what I have used above?

Thank you.

 

[Duane Hookom]

You stated "it works great" and it can't be a whole simpler since it doesn't
involve any code modules. There may be a better expression but I can't think
of it.

--
Duane Hookom
Microsoft Access MVP

Dear Mr.Hookom,

A better method.

Thank you.

I'm not sure what you are asking. Do you want a better method than I
suggested or are you asking why your solution didn't work as expected?
--
Duane Hookom
Microsoft Access MVP

Dear Mr.Hookom,

Thank you very much for your help, it works great.

BTW, is there any better way to achieve the same result than using I have?

Thank you

:

I would set the control source to:
=[total]*[taxrate] * Abs([YourYesNoFieldName])

--
Duane Hookom
Microsoft Access MVP


:


Hi, there,

I am building an invoice form which needs tax exemption case.

The first step I took was adding yes/no data type field to customer table.

Then, I put an invisible textbox named taxcode which bring the yes/no field
value when the invoice form loads by using onload command as follow:

If Me.taxcode = 0 then

Me.tax = 0

End If

The tax field has control source. (=[total]*[taxrate];Currency Format)

When a tax exemption customer loaded, the form gives a run time error, "You
can't assign a value to this object".

Could anyone tell me how to fix this problem? Moreover, is there any better
way to distinguish tax/none tax pay customer otherthan what I have used above?

Thank you.