New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Dim cmd1 As New ADODB.Command Dim rst1 As ADODB.Recordset 'Connect to db and run stored proc based on Client ID cmd1.ActiveConnection = CurrentProject.Connection cmd1.CommandType = adCmdStoredProc cmd1.CommandText = "usp_MarketingVisitationsGet" cmd1.Parameters("@ClientID") = Me.parent.txtClientID cmd1.Parameters("@VisitID") = Nz(Me.parent.cmbVisits, 0) 'Set the recordset Set rst1 = cmd1.Execute(
If Not rst1.EOF Then Me.scheduleComment = rst.scheduleComment End If
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.