Checkbox after Update Event

C

Carol Shu

if i enter a "date" in the field for customer who made the last car payment,
i like it automatic check the box "Paid in full", i think something to do
with " check box after update event" just not sure how to write the code,
please help.
 
M

Mr B

You can place the following statement in the "After Update" event of the date
field:

if not isnull(me.NameOfDateTextBox) then
me.NameOfCheckBox = true
else
me.NameOfCheckBox = false
end if

If you don't mind, why are you wanting to check a checkbox. If you are
entering a date in a field that represents the date when the borrower made
the final payment, you could just as easily check that field to determine if
they are "Paid In Full" else if there is no date in that field, they would
still have some payment to be made.
 
C

Carol Shu

I was going to do this - if user enter account "Closed", it must enter a
date, but i post the question here, didn't get helpful answer, so i went the
other way, whitch you just help me, thank you very much, or if you have a
better idea please let me know, thanks again.
 
M

Mr B

Carol,

I just thought that if you were going to have a data entered in a field that
represents that final payment, you would not need the checkbox. It is kinda
redundant.

Otherwise, I think you are on the right track with what you have.

Mr B
 
Top