I am using the date and time picker throughout my program and it works fine everywhere except on my continuous forms. I have the form's recordsource set to a query that gets the date from the date and time picker. The form and code works fine as long as the query finds matching records. If no matching records are found, and I attempt to change the date, I receive the following message.
Run -time error '2771':
The bound or unbound object frame you tried to edit doesn't contain an OLE object
Then it stops working altogether. I can get the form working with a textbox formatted to shortdate and have the user type it in, but since I'm using the control everywhere else, I'd really like to get it working on this form as well. I've searched the ee knowledgebase and saw others with this problem, but the solutions are not working for me. I'd really appreciate any help anyone could give. Thanks!