I am new to Visual Basic and I am trying to write a simple program. I have an Access Database that I have set up as an ODBC connection usign the ADODC form. When I draw the text boxes I see the data and I can scroll through it using the ADODC buttons.
However, I wanted to set something up so it could ask a user what date they needed and only display that data. Below is my code:Private Sub cmdgetdata_Click()
Dim dtDate As Date
Dim sSQL As String
dtDate = InputBox("Enter Date Needed")
sSQL = "Select * from MainData"
sSQL = sSQL & " WHERE Date = '" & dtDate & "'"
Adodc1.CommandType = adCmdText
Adodc1.RecordSource = sSQL
But when it runs it gets to the Adodc1.CommandType = adCMdTxt and errors - saying missing an object.
I can't figure this out although I am sure it is pretty easy.