I have a form where I have event macros to link to other forms. However I cannot get the macro to work on date fields - any ideas?
I have a form where I have event macros to link to other forms. However I cannot get the macro to work on date fields - any ideas?
More information required.
On which event is the macro set up?
on double click
Have you tried some vba code instead? This works with me:
Private Sub OpenAll()
If Me.Dirty And Nz(Me![RequiredField], "") <> "" Then DoCmd.RunCommand acCmdSaveRecord 'All one line where [RequiredField] is a must have field.
If IsNull(ID) Or ID = "" Then
DoCmd.OpenForm "FormName", acNormal, , , acFormAdd
Else
DoCmd.OpenForm "FormName", , , "ID = " & ID
End If
End Sub
I then call the sub routine from the on double click event of each of the fields, including the date fields, and the form is opened.
Good luck