field update

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
 
R

Rick Brandt

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
 
B

Bert-jan

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project Center-Autolink column fields 0
Split form 0
How to automate update on weekly reports spreadsheet 0
Insert Multiple Fields without Dialog closing between each... 0
Making a macro only work on certain files 2
Page numbering with Merged Document and IF statements 1
ASK Field Formatting 1
Calendar Control - help to avoid resetting to Date() ? 0

Top