Formula for fields in Access

[Guest]

I am trying to create a table and form for an order form that will eventually
be on the web. I have the sales tax rates for the counties in each of the
states in it's own table. I want to make this formula put the correct sales
tax rate in the field for sales tax rates, based on the state and then the
county. Once this is completed, I want to set a formula to only enable the
customer to select a county of the selected states that we will be collecting
sales tax for. If it is not any of the selected states (right now it is just
one state) I do not want the customer to be able to put a county in the
county field and thereby, the sales tax rate is not applicable either.

Is Access able to do this?

 

[Brendan Reynolds]

You could do this in an Access form, Linda, but Access forms do not run on
the Web, so if your goal is to create a form that can be used on the Web,
there would seem to be little point in pursuing this further in Access.

If you still want to know how to do it in an Access form, you would do it by
using two combo boxes, one for the states and one for the counties. When the
user chose a state, you would filter the second combo box to show only
counties in that state. There's an example at the following URL ...

http://www.mvps.org/access/forms/frm0028.htm

The logic will probably be similar in your web form, but the implementation
will depend on what technologies you use to build your web application.