I have an Edit Form (only edit) that has among other things a checkbox, and a date picker. User won't be allowed to change dates on the date picker, only by checking/unchecking the checkbox will the date change to either Today or Blank. Because it is an Edit Form, the date picker may already have a date in it, so on the for the checkbox I added:
receivedCB.Default = If(IsBlank(received.SelectedDate), false, true)So, if the date picker is empty, the checkbox will be unchecked, and vice versa. This part works as expected. What I need is that if the user unchecks the checkbox it would empty the date picker, and if on the contrary the user then checks the checkbox again, the date picker "selectedDate' would be set to Today(). Being this an Edit Form, the default value for the date picker will be Parent.Default. So, I can't figure out how to do this. I was thinking about setting a variable:
receivedCB.OnCheck = Set(DateReceived, Today());
receivedCB.UnCheck = Set(DateReceived, Blank());Adding this to the date picker won't work, because if the date picker is not empty already, it'll change the date to Today:
received.DefaultDate = If(IsBlank(DateReceived), Parent.Default, DateReceived)I would appreciate any lead on this. Thanks.

Report
All responses (
Answers (