Forms -- "Tax Table"

[Debris]

Hello,

Let's say I've got a table that lists all fifty states and a tax rate
associated with each.

As would be expected, I would like a user to be able to change / update the
tax rate, but not change the state name, nor add / delete records.

I'd like a form that displays all fifty records (state name & tax rate
fields) at once, and the user scrolls up/down to find the entry they want to
change. But, only the tax rate field is "live" -- i.e., data can be
entered.

In my mind I see a form that lists the state in a "label" - type format,
with a text box next to it for entering the rate.

Is such a thing possible? Any suggestions on where to start? I think I
want to create a form in Tabular view, and I know there's a way to display a
field without allowing changes (not sure off the top of my head how it works
but I can figure out that part). Am I on the right track?

Thanks, D

 

[Tom Lake]

In my mind I see a form that lists the state in a "label" - type format,

with a text box next to it for entering the rate.

Is such a thing possible? Any suggestions on where to start? I think I
want to create a form in Tabular view, and I know there's a way to display
a field without allowing changes (not sure off the top of my head how it
works but I can figure out that part). Am I on the right track?

In the properties of the State textbox, set Enabled to No and Locked to Yes.
Also remove the State textbox from the Tab order.

Tom Lake

 

[John Vinson]

Hello,

Let's say I've got a table that lists all fifty states and a tax rate
associated with each.

Sales tax rates?

Consider New Mexico. Last I checked there were over forty different
tax rates, depending on WHERE in the state the sale occurred! Many,
many states have local sales taxes in addition to a statewide tax.

Tax management is *not* fun...

As would be expected, I would like a user to be able to change / update the
tax rate, but not change the state name, nor add / delete records.

I'd like a form that displays all fifty records (state name & tax rate
fields) at once, and the user scrolls up/down to find the entry they want to
change. But, only the tax rate field is "live" -- i.e., data can be
entered.

Use a Continuous Form; include the state (I'd suggest the two-letter
code, or the state name if you really prefer) and a field for the tax
rate (if you decide you can get by with just one). Set the Enabled
property of the State control to No, and its Locked property to Yes.
The user will be able to see it but not change it.


John W. Vinson[MVP]

 

[Debris]

Thanks guys for the help. That's exactly what I was looking for.

FYI, I also set AllowAdditions to No on the form's property sheet (to
prevent any erroneous additions to the table), and I reformatted the State
box to remove its "box" / "data entry" look and give it more of a "label"
look.

Re: wild and crazy tax rates, to make a long story short we just have to
worry about the *state* tax rate, not the local ones... but yes it can be
fun...

Thanks, D