Hey,
I have a continuous form that should populate the output from a SQL query.
Code:
Private Sub Form_Load()
Dim A As New ADODB.Recordset
Dim DC As New DataConnection
Dim strSQL As String
strSQL = "SELECT FULL_NAME as NAME, PHONE as DIAL, LOCATION as ADDRESS from table;"
A.Open strSQL, DC.ConnectionProperties, adOpenKeyset, adLockOptimistic
Set Me.Recordset = r
End Sub
The DC.ConnectionProperties is the connection string that is already defined and it working as expected, since I use the same connection for other queries as well.
Below is the debugging that I have already performed and are producing the output as expected in the Intermediate window
- SQL query is correct.
- debug.print field
- debug.print value
- debug.print recordcount
- Control source has not been changed and they are as-is.
What other debugging that I can do to check to see the issue?