Form data entry

  • Thread starter Thread starter Charles G via AccessMonster.com
  • Start date Start date
C

Charles G via AccessMonster.com

First of all, I'm not even sure this is possible. I have a form for entering
coin denominations [Pennies] [Nickels] [etc]. If I have a field [Service Code]
in my table, is there a way to automatically populate that field with the
service code "385" when any amount is keyed into one or more of the coin
denomination fields? On the contrast when a amount for [Total Currency] is
entered into the same form in the [Total Currency] textbox, it automatically
populates my [Service Code] field in my table with "390."

Currently, my form includes a combo box that the user can select "385" and
enter the coin denominations or enter "390" and enter the [Total Currency].
However, with this system, a user can accidently select "385" for coin and
enter currency.

I want to eliminate the combo box to make the form more "idiot" proof and
have the correct service code entered into my table when ever certain fields
are activated.

-Charles-
 
Charles

If "385" and "390" are the only two codes, you could also get by with an
option group, instead of a combo box.

If you are saying that you have a control on your form for [Total Amt], one
approach might be to use the presence/absence of a value in that field to
set your code. I can imagine a form that starts out with both "coin" and
[Total Amt] controls enabled, but disables the "other" field(s) as soon as a
value is entered. And this still wouldn't require storing a code, as it
could be derived (calculated) from what else was already stored.

Regards

Jeff Boyce
<Access MVP>
 
"385" for coin and "390" for currency are the only two service codes. The
database is at work, but I would love to have something that when a certain
field is activated, it shoots the appropriate [Service Code] in my table.

I'll give it a shot on Monday. Thanks.
 
Charles

One of my points was that you might not NEED to store a service code if it
can be derived from knowing which fields are filled.

Regards

Jeff Boyce
<Access MVP>
 
Back
Top