Sorry about that. I uploaded the wrong version
New form OT_Board_New with a record source using new query qryAssRank (with Serialize function).
I've left all _old items but once you're happy with this those can be deleted
Have modified test data dates so these included today's date
I've added the AssRank field to the left of the form and made the Shift Hours visible so I could easily enter data
As far as I understand it the form is taking data for today's date only so I've based my solution on that. If not, it will need further tweaking later.
FIXED version attached
Hi Ridders,
Just a quick observation/question, the form and qry you supplied works well if you wish to only use the current date(today), but I wish it to not just take the records for the current date only, I originally had it open up to a user date selection via a datepicking form so as when the user clicked the textbox = txt_OTDate on the form ,they could then jump to those records for the date selected.
I noticed that you commented this out, but this was and needs to be big part of the functionality. So I attempted to alter your query/criteria by changing one field from = date() to > = Forms![ot_board]![txt_OTDate], and thought it would be a simple as that, but not as I am now getting the same errors once again now
Code:
InputDateField txt_OTDate, "Select A Date to view Availability for O/T"