Checkboxes

[Carrie]

Hi

I was wondering if someone could help.

I have a check box field and when I click yes for this field I would like another field to update with the following data "interviewing".

Does anyone know how to do this as I'm a bit stumped.

Thanks in advance

 

[WayneRyan]

carrie,

Use the BeforeUpdate event:

If Me.cbxMyCheckBox = -1 Then
Me.txtOtherField = "Interviewing"
End If

The -1 means True or Checked
A 0 would mean False or Unchecked

Wayne

 

[boblarson]

For simplicity's sake, you don't have to use -1 and 0. Just use =True or =False and it will work just as well.

 

[Pat Hartman]

You need to take this one step further if you want the variable to be displayed when you scroll to a different record. You'll need the same code in the OnCurrent event.

 

[Rich]

You could of course achieve the same result without any code, just set the control source of the textbox to =Iif([MyField]=True,"Interviewing","Something Else")