hi there
ive got a little problem with VBA
i have a command button and a text field in my form
with the button i want to write the current date in the text field
but if the field is not empty the button should do nothing
here is my current code:
Private Sub Button_Insert_Date_Click()
Dim Date1 As Date
If Forms![F_Auftagsdaten]![Erlaedigt_am] = "" Then
Forms![F_Auftagsdaten]![Erlaedigt_am] = Date1(Date)
End If
End Sub
i hope i wrote my problem understandly for you
thanks
ive got a little problem with VBA
i have a command button and a text field in my form
with the button i want to write the current date in the text field
but if the field is not empty the button should do nothing
here is my current code:
Private Sub Button_Insert_Date_Click()
Dim Date1 As Date
If Forms![F_Auftagsdaten]![Erlaedigt_am] = "" Then
Forms![F_Auftagsdaten]![Erlaedigt_am] = Date1(Date)
End If
End Sub
i hope i wrote my problem understandly for you
thanks