If Statement

  • Thread starter Thread starter NEC-2008
  • Start date Start date
N

NEC-2008

What I'm trying to do is, in a date field, on "has focus", if related "check
box" is positive (yes) then insert current date + (plus) 45 days. (to present
a future date).
Is there any help out there?
 
Private Sub DateField_GotFocus()
If Me.CheckBox = -1 Then
Me.DateField = DateAdd("d", 45, Date)
End If
End Sub
 
You must log in or register to reply here.

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

Form with preset tasks 0
Excel Excel Show Countdown Date 7
Combo box default value 3
If Then Statements 2
if or and expression 5
Use one field to automatically determine data in another field 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Conditional Calculated Field 0

Back
Top