Is it possible to limit date selector on subform for months range on parent form

[Delta729]

I'm trying to learn a little about Access and I was just seeing it there was a way to limit the days selection on a subform. The parent form is called [frmMonthList] and child form is called fsubMonthList. In the subform there is a PaymentDate field that I wondering if I can limit the date selector option to the MoStart & MoEnd dates (basically, between these dates) on the parent form.



I've was looking around for hours earlier on the web, but couldn't find anything about if it was possible. Let me know if you have any questions, I'm just trying to learn a little so be kind on the feedback.

[Delta729]

I got part of it to work, but I can seem to limit by the start and end. I have

>=[Forms]![frmMonthList]![MoStart]

. Not even close, but a possible start in the right direction.

[moke123]

I doubt you can change the native date picker but you could probably write a custom date picker.
The simplest way however is to validate the date chosen with something like this:

Private Sub PaymentDate_BeforeUpdate(Cancel As Integer)


    If Me.PaymentDate < Parent.mostart Or Me.PaymentDate > Parent.moend Then
        Cancel = True
        Me.Undo
        MsgBox "No good"
    End If
    
End Sub

[Delta729]

That'll do the trick. Thank you very much.