Help Needed Programing Two boxes!

[stu_C]

Hi all
Ill try and explain what I need to do,

In 'Box A' you type the amount of days you require then save.

After a few weeks Ill recieve an actual amount for the car cost then i type in £'s the amount in 'Box B'

What I need to do is when 'Box B' has an amount more than Zero the amount of days automatically goes to Zero

is is possible to set this in a query?



Thanks!

[RuralGuy]

You could certainly do it in the AfterUpdate event of the 2nd box.

[stu_C]

what in a form? anyone know the code to do this?

[RuralGuy]

You will have to use your control names but it would look something like:
If Me.BoxB > 0 Then
Me.BoxA = 0
End If