Attached is an Access database example that I am working on.
When I open the Daily Work Scheduling form I can change to different records and cboTask is empty however there is a record for cboTask in tblProjects. What's even weirder is that cboTaskID remains populated.
What I am having trouble with is having the values stick per record I review on Daily Work Editing form based off the table AND when I choose a task from the drop down it either automatically clears cboTaskID or autopopulates it (since the query it runs only turns up 1 code each time anyway). Whichever is easier. Thanks for your review guys!