"...An error occurred on a call to the Windows Date and Time Picker Control."
I think the dtpicker is unfairly being picked on. May be a Red Herring.
I get this error in the after_update event of a combobox in my form, ...on some records, not on others, and not always the same records! Is there a sequence issue here?
The cbobox is unbound and I set the recordsource to a query on a table from within the module. The rest of controls on the form fill with data from the current record (and associated queries on other tables), some bound, some unbound. The dtpicker is unbound and value is set in module...
Me.OrderEditDate = DLookup("orderDate", "qryOrdersFilteredForEditcbo"
I had a problem when I first inserted the dtpicker. It choked when other textboxes that were bound, were also defined in the module (redundant) but had nothing to do with the dtpicker. (can't remember the error message, but the debugger pointed to the dtpicker line in the module.)
Please help!
I am learning Access and VB as I go, so there are huge knowledge gaps.
Daniel.
I think the dtpicker is unfairly being picked on. May be a Red Herring.
I get this error in the after_update event of a combobox in my form, ...on some records, not on others, and not always the same records! Is there a sequence issue here?
The cbobox is unbound and I set the recordsource to a query on a table from within the module. The rest of controls on the form fill with data from the current record (and associated queries on other tables), some bound, some unbound. The dtpicker is unbound and value is set in module...
Me.OrderEditDate = DLookup("orderDate", "qryOrdersFilteredForEditcbo"
I had a problem when I first inserted the dtpicker. It choked when other textboxes that were bound, were also defined in the module (redundant) but had nothing to do with the dtpicker. (can't remember the error message, but the debugger pointed to the dtpicker line in the module.)
Please help!
I am learning Access and VB as I go, so there are huge knowledge gaps.
Daniel.