What am I missing, I am stuck!

Have you declared rs as recordset?

Is WeekInput a number or short text field?

yes sir on Dim rs As ADODB.Recordset
weekinput in the table is a number

Dim rs As ADODB.Recordset
Set rs = New ADODB.Recordset

Hmm and WkNumInsp is spelled correctly... That error usually comes up when it doesn't recognize something and wants a parameter. Is WeekPayForInspector a table or a query?

WeekPayForInspector data is from a query

OK now we have something that could make sense to want information. Can you upload an image of the query design view?

What are the values of the other inputs?
CurrentProject.Connection

Based on your first image, it appears to me that your sqlstring is returning WkNumInsp as a string rather than a number.  WeeKInput = "25"

Can you post a screenshot of the results of the msgbox please?

with more frustrating digging, I figured out that my query had some criteria that asking from another form. I am closer to an answer now, I got the sql statment to work, sorta
Dim SweekInput As String
Dim Syear As String

SweekInput = Forms!PayInspectorbasedInvoiceProfit.WeeKInput
Syear = Forms!PayInspectorbasedInvoiceProfit.YearFilter

sqlstring = "SELECT * FROM WeekPayForInspector WHERE wknuminsp =" & SweekInput

however I am goofing up the where clause to get two conditions to work
I want the where to look for two unbound items on my form
sqlstring = "SELECT * FROM WeekPayForInspector WHERE wknuminsp =" & SweekInput AND YearInvoice = Syear

Yea I figured it was query criteria once we got there.

"SELECT * FROM WeekPayForInspector WHERE wknuminsp =" & SweekInput & " AND YearInvoice =" & Syear