Unanswered: storing SQL result into a VB variable?
Here's my question, I am using a button to peform the following event code,
basically I am trying to store the result of a quiery into a VB variable for
later use... how can this be done?? any help is thanked in advance again!
Dim MyVariable As String
MyVariable = DoCmd.RunSQL "SELECT Name FROM createNeweDLPIRecord WHERE
A sql statement will always return a recordset. Even if it has only one record and one column it is still a recordset. Get the information into the variable the same way you would if you wanted the first record, first column.