default value ?

Hi
I have a form on which one field is a metric.
there is a later field with the imperial equivalent - how can i get it to
default to this ?

Mike

One way is to have this as the After Update event for the MetricValue
control:[ImperialValue] = [MetricValue] * Conversion Factor

"mikey" wrote:

Hi
I have a form on which one field is a metric.
there is a later field with the imperial equivalent - how can i get it to
default to this ?

Mike

I've tried
[Distance (imp)] =[Distance (metric)]*0.6213712
in the default value, beforeupdate and afterupdate events, and it doesn't
seem to make any difference - the value 0 is always displayed and updated to
the table ? What could I be doing wrong ?

Mike

"BruceM" wrote in message
...
One way is to have this as the After Update event for the MetricValue
control:[ImperialValue] = [MetricValue] * Conversion Factor

"mikey" wrote:

Hi
I have a form on which one field is a metric.
there is a later field with the imperial equivalent - how can i get it
to
default to this ?

Mike

I don't know if it makes any difference, but I would avoid the use of
parentheses in field names. If Distance(imp) is the field name I would go
with something like DistanceImp instead. I would name the text box bound to
that field txtDistanceImp.
There is no reason to store a calculated value. You can calculate on the
fly in a query, or in a control on a form or report. If you bind the metric
value to a field in your table, the imperial value text box will be unbound.
If you will always be entering the metric value all you need to do is to set
the Control Source of the imperial value text box to =[txtDistanceMet] *
conversion factor.
If you will be entering initial values in either text box then you will need
to handle assigning a value to the unbound text with On Current code
(although you could run the code elsewhere), and using the After Update event
of the unbound text box to assign a value to the bound field's text box. Or
something like that, which could vary depending on details.

"mikey" wrote:

I've tried
[Distance (imp)] =[Distance (metric)]*0.6213712
in the default value, beforeupdate and afterupdate events, and it doesn't
seem to make any difference - the value 0 is always displayed and updated to
the table ? What could I be doing wrong ?

Mike

"BruceM" wrote in message
...
One way is to have this as the After Update event for the MetricValue
control:[ImperialValue] = [MetricValue] * Conversion Factor

"mikey" wrote:

Hi
I have a form on which one field is a metric.
there is a later field with the imperial equivalent - how can i get it
to
default to this ?

Mike

There is no reason to store a calculated value. You can calculate on the
fly in a query, or in a control on a form or report.

That is very true.....