424 - Object Required - Which one?

Code:

---

Private Sub Form_Load()

Text1.Text = Date
Text2.Text = Date

End Sub

---

The debugger targets "Date" as being the culprit.
Which reference am I missing for it to load when executed?

I've added Microsoft ActiveX Data Objects 2.6 Library to the default.

Well you can tell I'm a rookie.

I had renamed my text boxes (Originally Text1 and Text2 but now StartDate and EndDate) therefore this was the issue from the get go.

Issue resolved :)

Put

Code:

---

Option Explicit

---

in the Declarations Section of your Form and run the code again. I suspect you'll find that either Text1 or Text2 doesn't exist

EDIT:I see you got there before me !!