New Record Validate

[brucey54]

Hi folks, I’m trying to do the following;

If a new record is created, insert date only if customerID is not null

Private Sub Form_Current()
If "CustomerID", "TblDietPlan" = <> 0 Then
If Me.NewRecord Then Me.MealDate = DMax("MealDate", "TblDietPlan")
End Sub

 

[brucey54]

Hi folks, any help with this would be much appreciated
Brucey