I'm trying to pass 2 parameters from my form controls to the stored procedure to fill my rowsource.
I'm using the kind of solution found here on tek-tip (and shown beneath) but don't know how to pass my second parameter!
My first parameter is an integer and my second varchar
Private Sub Last_Click()
' --- This resets the query for the last names ----
Dim FoundLastName As String
FoundLastName = Forms![frm_record_find].FindLastName
FoundLastName = "%" + FoundLastName + "%"
Me.List19.RowSource = "Exec FindLastName @LName = ' " &
FoundLastName & " ' "
Me.Repaint ' Save data for query
Me.Refresh ' Requery drop down listing
End Sub
I'm using the kind of solution found here on tek-tip (and shown beneath) but don't know how to pass my second parameter!
My first parameter is an integer and my second varchar
Private Sub Last_Click()
' --- This resets the query for the last names ----
Dim FoundLastName As String
FoundLastName = Forms![frm_record_find].FindLastName
FoundLastName = "%" + FoundLastName + "%"
Me.List19.RowSource = "Exec FindLastName @LName = ' " &
FoundLastName & " ' "
Me.Repaint ' Save data for query
Me.Refresh ' Requery drop down listing
End Sub