424 - Object Required - Which one?

[Evilbyte]

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.

[Evilbyte]

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

[Doogle]

Put

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 !!