Okay here is my code:
If optName.Value = True Then
Dim strSQL As String
strSQL = "SELECT * FROM Usages WHERE UsageID = " & List2.Text & ""
Adodc1.RecordSource = strSQL
Refresh is causing an error in from clause??
I tried setting my adodc1 to an adcmdunknown recordsource, with no avail. i then get no recordsource specified error.
please help me with this, i am at my wits end. i have looked it up, i can't find the answer anywhere. the microsoft website has an explanation but i can't figure out how to solve it.