I have a calendar control on my main form. I have a WorkDate field in my subform. In the query of my subform, I set the criteria for WorkDate to
forms!MainForm!acxCalendar
When I choose a date in the calendar, all the record of that day appear.
When I click AddNew navigating button, I want to see the WorkDate field to be filled in with the date on the calendar control. I later want to delete this field (if this works), but the date is still recorded in another table.
My problem is, I cannot the date to work with AddNew. Please someone help me.