I have a fairly simple task, or at least I think it should be. I have
a report with two fields on it,
BadgeIn (text)
BadgeOut (text)
chkIncorrect (yes/no)
I want to check if these values are equal and if they are not, update
an outbound checkbox to true. When I try to code the report on the on
open, nothing works. Which event should I be putting my code in? The
below code is what I have.
if BadgeIn <BadgeOut then
chkIncorrect.value = true
else
chkIncorrect.value = false
end if
I have also tried
if BadgeIn.value <BadgeOut.value then
chkIncorrect.value = true
else
chkIncorrect.value = false
end if
Any thoughts?
Dave