Changing Values

[Guest]

Hi

I have a tick box on the clients form that gets ticked if they cease using
our service. What i require is that once they click the save command button
i require the active status to change to inactive if that box is ticked.

Is this possible

Thanks

 

[Guest]

I'm assuming you have a 'Status' control on your form?!

Simply use code similar to:

If Me.CheckboxName=True then
'Client ceased using your services
Me.StatusControlName="inactive"
Else
'Client still uses your services
Me.StatusControlName="active"
End If

This advise is based on many suppositions as you did not provide much detail
about your form... If you provide more info, such as control names, we could
help you better.

Daniel