Recent content by Sunglow08

Thank you, I think I just fixed my problem when you said check the column count property in the listbox. Thank you so much

Thank you for the date tip, although the date is not my issue. I did apply your date tip to the code.

The debugging will only work if the entire statement gets executed which because that one thing is coming up null it is not executing the entire line of code. I checked the columns in the query and it is the 9th column since the first column always starts with 0. The code syntax is correct, it...

Can you provide me an example of how to do that code so I can do the check?

Any suggestions would be appreciated? Please provide examples --I am still new to VBA coding in Access and need all the help I can get.

Private Sub ProcessApproved() Dim item As Variant Dim lst As ListBox Dim rstNew As DAO.Recordset Dim rstEmp As DAO.Recordset Dim fld As DAO.Field Dim lngFldCounter As Long Dim rst As DAO.Recordset Dim lngNewID As Long Set lst = Me.lstTermEmpl For Each item In lst.ItemsSelected...

For Each item In lst.ItemsSelected CurrentDb.Execute "UPDATE tbl_Staffing SET Term_Heat_Ticket_Num = '" & _ Me.TxtTerm_Heat_Ticket_Num & "', Inactive_Status_Dt = #" & lst.Column(7, item) & _ "#, Termination_Reason_FK = " & lst.Column(9, item) & " WHERE ID = " & lst.Column(8...