Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rowsource with sproc, 2 parameters doesn't work

Status
Not open for further replies.

giovi2002

Programmer
Aug 22, 2005
47
NL
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


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top