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"