Populate one field based on another fields value

[Guest]

I think this is a simple question. Let's say I have a form that has two
fields in it one is named "Line Number" the other is named "Charged". The
field "Charged" is formatted as currency.
So what I want is if the value in the Field "Charged" is grater than $0.00
then put a "1" in the "Line Number" field.

Thank you for any help!!!!!!

 

[Jeff Boyce]

Alan

If knowing a value for [Charged] causes a set/known value for [Line Number],
then do you really need a field for that? You could use a query to
"calculate" the second value from the first, and avoid considerable
synchronization work.

Is your [Line Number] field on the form bound to an underlying field in a
table?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

I think this is a simple question. Let's say I have a form that has two
fields in it one is named "Line Number" the other is named "Charged". The
field "Charged" is formatted as currency.
So what I want is if the value in the Field "Charged" is grater than $0.00
then put a "1" in the "Line Number" field.

Thank you for any help!!!!!!

The Line Number field should not be stored in any table, if in fact it
can be derived from [Charged]. You can put a Textbox on your form with
a control source

=IIF([Charged] > 0.00, 1, 0)

to display a 1 if Charged is greater than 0, and display 0 otherwise.

John W. Vinson[MVP]