Check box automatically clicked upon change of date

[Rita K]

Hey, I'm quite rusty in VB so please be patient with me. I'm trying to make a query where the check box will be automatically clicked when the input date is after the 5th.

For example, for Oct, the input date is Oct 6th, 1999, the check box should be true.

For Nov, input date is Nov 3th, 1999, check box should be false.

Can anyone please help? Thanks so much.

[smartchap]

Check the date portion of the Input Date if it is >=6 then make CheckBox.Value= True else False.