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!

Hi JK,
try putting this air code on the Current event for the form.

If Not IsNull(Me!VendorTaxRate) Then
Me!SalesTaxRate = Me!VendorTaxRate)
End If

Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"JK" <jasonk at necoffeeco dot com> wrote in message
news:3D293867-2F31-456F-87D2-(E-Mail Removed)...
>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!