Check Box status

[NOTLguy]

Is it possible to change the status of a check box ( Client_Status_Active)by entering a date in a date field?

If IsDate(DeathDate) then
Client_Status_Active = False
Endif

Regards,


Bill

[RuralGuy]

Yes, of course. Have you tried it?

[NOTLguy]

Yes, of course. Have you tried it?

I tried it and got an error message as follows:

Run Time error '-214735252567 (80020009)
You can't assign a value to this object

Debugger stops on the line:

Client_Status_Active = False
This field is a Yes/No data type.

Bill

[RuralGuy]

Do you have this field bound to a control on the form? If so then make sure the name of the control is different (chkActive maybe??) then change the code to:

If IsDate(DeathDate) Then
   Me.chkActive = False
Endif

[NOTLguy]

Do you have this field bound to a control on the form? If so then make sure the name of the control is different (chkActive maybe??) then change the code to:

If IsDate(DeathDate) Then
   Me.chkActive = False
Endif

That worked perfectly! Many thanks for your continued help with the issues I am facing.

Regards,
Bill

[RuralGuy]

Glad to help. Don't forget to use the Thread tool and mark this thread as Solved.