C
CW
I have a costing form on which users will enter the description of crates to
be used, and the costs will be generated and totalled.
There are 10 lines and on some records there may be no crates, on others
there may be several.
There is a description field and then another field on each line that holds
the cost of the crate. This is a fixed amount of 60.00 for each crate that is
used.
I cannot use a default value of 60.00 as this would lead to a total of
600.00 on every record regardless of whether any crates had been specified or
not.
I want the value of 60.00 to appear automatically in the cost field on a
line ONLY if a user actually enters something in the description field on
that line.
It should not be triggered by the focus going into a description field, as a
user may well tab through all the lines as part of the page navigation.
I am assuming it needs a piece of code that will be kicked off On Change, or
something like that, in the Description field, and I have tried several
expressions but nothing worked!
I am sure this is quite simple and somebody will have the answer rightaway?
Many thanks
CW
be used, and the costs will be generated and totalled.
There are 10 lines and on some records there may be no crates, on others
there may be several.
There is a description field and then another field on each line that holds
the cost of the crate. This is a fixed amount of 60.00 for each crate that is
used.
I cannot use a default value of 60.00 as this would lead to a total of
600.00 on every record regardless of whether any crates had been specified or
not.
I want the value of 60.00 to appear automatically in the cost field on a
line ONLY if a user actually enters something in the description field on
that line.
It should not be triggered by the focus going into a description field, as a
user may well tab through all the lines as part of the page navigation.
I am assuming it needs a piece of code that will be kicked off On Change, or
something like that, in the Description field, and I have tried several
expressions but nothing worked!
I am sure this is quite simple and somebody will have the answer rightaway?
Many thanks
CW