Carring dates in Access form

[Rjconrep]

I have a command button that I want to carry all the dates on my form by 1 day. However, where there is a box with no date I need it to do nothing in that box. I want it to only carry the date where there is a date already in the box. Can anyone help me with this? Here is what I have now:

If Len(Nz([To_DocuTech], "&quot) = 0 Then
[To_DocuTech] = ""
Else: [To_DocuTech] = To_DTP + 1

End If

 

[3587]

Try this,

If Isnull(Me.[To_DocuTech]) Then
'DO NOTHING HERE.
Else
Me.[To_DocuTech] = Me.[To_DTP] + 1
End If

 

[Rjconrep]

I am getting an Object required error

 

[3587]

What version of Access are you using?
Are To_DocuTech and To_DTP the names of controls on a form, a variable, or what?

Try this,

To_DocuTech must be the name of the control on your form that has the date to be increased by one day.

If Isnull(Me.[To_DocuTech]) Then
'DO NOTHING HERE.
Else
Me.[To_DocuTech] = Me.[To_DocuTech] + 1
End If