Hello everyone

I am trying to add the timesheet to the database which I built in an earlier class everything is working as far as I can see except that doesn't ask me do I want to create an invoice and it doesn't hide there invoiced items I must have missed something out here is the code that I have in the button which does the invoicing

I have been trying for the last 4 days to sort this problem out here is the code that I have


Private Sub Command80_Click()
DoCmd.SetWarnings False
    DoCmd.RunSQL "UPDATE TimesheetT SET IsInvoiced=TRUE WHERE CustomerID=" & CustomerCombo
    DoCmd.SetWarnings True
    Me.Requery
End Sub

Private Sub Duration_Click()

End Sub

Private Sub EndTime_AfterUpdate()

    If EndTime < 1 Then EndTime = Date + EndTime
    
End Sub

Private Sub MinutesWorked_Click()

End Sub

Private Sub StartTime_AfterUpdate()

    If StartTime < 1 Then StartTime = Date + StartTime
    
    
End Sub