Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dtpicker Run-time error 2147352567

Status
Not open for further replies.

diwin

Technical User
Nov 29, 2002
218
CA
"...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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top