Invalid Use of Null.. Cannot find it

[Mackbear]

Hi everyone, I hope you can help. This is driving me crazy. I have a query that was previously working literally just a while ago and suddenly I am getting "Invalid Use of Null"
I cannot see the cause of this problem. What could be causing thissss? The query, I checked all fields while on debug and there is no NULL. Please help!:

"UPDATE tbl_LFMngment SET tbl_LFMngment.[LFWaiverStatus]='" & Me.waivapp & "', tbl_LFMngment.[RequestMethod]='" & Me.reqmethod & "', tbl_LFMngment.[CreditMethod]= '" & Me.credmethod & "', tbl_LFMngment.[ExpDatetoCredit]= #" & Me.ExpDatetoCredit & "#, tbl_LFMngment.[DeclinedReason]= '" & Me.decreason & "', tbl_LFMngment.[LFReviewStatus]= 'Open', tbl_LFMngment.[LFWaiverReqBy]= '" & Me.ReqbyAP & "', tbl_LFMngment.[LFWaiverReqDate]= '" & Me.ReqDate & "', tbl_LFMngment.[LFWaiverReqDateTime]= '" & Me.ReqDateTime & "', tbl_LFMngment.[LFWaiverReqWeek]= '" & Me.ReqWeek & "', tbl_LFMngment.[LFWaiverReqMonth]= '" & Me.ReqMonth & "', tbl_LFMngment.[RequestStatus]= '" & Me.stat & "',tbl_LFMngment.[LFReqByFullName]= '" & Me.apfullname & "' WHERE tbl_LFMngment.[entryid_LFmng] IN (" & Replace(SelectedList, "|", ",") & ")"

 

[arnelgp]

maybe SelectedList?

 

[theDBguy]

Hi. Are you assigning this SQL into a String variable? If so, try printing the string variable to see where the Null value is.

 

[plog]

Don't give us the blueprints of the building that has a door that won't close, show us the building itself.

What you gave us is how you build the string that becomes the SQL that will run. Show us what actually is built for that string after all the variables' values get dumped into it.

 

[Mackbear]

maybe SelectedList?

Right! I realized I have not selected anything yet :banghead: so foolish of me :banghead: I apologize.....

 

[theDBguy]

Right! I realized I have not selected anything yet :banghead: so foolish of me :banghead: I apologize.....

Hi. Glad to hear you got it sorted out. Goody eye, Arnel!!!