J
JK
I have a workorder form in access 03; on this form I have three tabs - one is
for parts, one is for labor and the last one is for vendor parts/labor. If we
do not do the work ourselves we outsource the work to one of our vendors.
These vendors are all over the country so I need to deal with the sales tax
rate for each vendor.
My default sales tax text box is pointed to the My Company Info table.
However, I want the form to basically say, if VendorTaxRate is not null then
change the SalesTaxRate to be whatever the VendorTaxRate is.
I've tried this is the forms after update event but I've been getting all
kinds of strange errors and once it even crashed my form.
What is the correct way to do this?
Thx so much for your help!
for parts, one is for labor and the last one is for vendor parts/labor. If we
do not do the work ourselves we outsource the work to one of our vendors.
These vendors are all over the country so I need to deal with the sales tax
rate for each vendor.
My default sales tax text box is pointed to the My Company Info table.
However, I want the form to basically say, if VendorTaxRate is not null then
change the SalesTaxRate to be whatever the VendorTaxRate is.
I've tried this is the forms after update event but I've been getting all
kinds of strange errors and once it even crashed my form.
What is the correct way to do this?
Thx so much for your help!