field update

  • Thread starter Thread starter Bert-jan
  • Start date Start date
B

Bert-jan

hello
is there a way to update a field when i check another field.
I have a yes/no field and when i select yes then another field most store
the current date
how do i do this
thank Bert-Jan
 
Bert-jan said:
hello
is there a way to update a field when i check another field.
I have a yes/no field and when i select yes then another field most store
the current date
how do i do this
thank Bert-Jan
Click to expand...

Use the AfterUpdate event of the CheckBox

If Me.CheckBoxName = True Then
Me.TextBoxName = Date()
Else
Me.TexBoxName = Null
End If
 
Tanks Rick


Rick Brandt said:
Use the AfterUpdate event of the CheckBox

If Me.CheckBoxName = True Then
Me.TextBoxName = Date()
Else
Me.TexBoxName = Null
End If
Click to expand...
 
Back
Top