How do I restricting date input to only Sunday

[PCX]

I have a form that the user needs to enter a date. This date always needs to be a SUNDAY. How do I restrict the entry to only Sunday or at least give an error message and take the user back to the Date Field to retry.

I tried to create a table that had ONLY sunday dates but when linked to it, all the dates come up and I have to scroll down three years of dates to get the one I want.

Thanks,
PCX

 

[dneufarth]

Try the weekday capability of the DatePart function. By default it will return '1' if the date is a Sunday.

Dave

 

[Guest_imported]

Working with what neufarth wrote, I would try something in the Before Update Event:

Private Sub CategoryName_BeforeUpdate(Cancel As Integer)
If (VariableWithDatePart) <> 1 Then
MsgBox &quot;Enter a Sunday or else ...&quot;
Me!DateField.SetFocus
Else
Me!YourNextField.SetFocus
End If
End Sub