Which part of this code is required two filter by customer

Option Compare Database
Option Explicit


Private Sub ContactBtn_Click()

    DoCmd.OpenForm "ContactF", , , "CustomerID=" & CustomerID
    
End Sub


Private Sub TimesheetBtn_Click()

    If TimesheetShowAll Then
        DoCmd.OpenForm "TimesheetF", , , "CustomerID=" & CustomerID
    Else
        DoCmd.OpenForm "TimesheetF", , , "CustomerID=" & CustomerID & " AND IsInvoiced=FALSE"
    End If
    
End Sub

I have built as far as customer ID combo box on the timesheet extended video

Just something else I have just had another look at the coding I would want the button on the water details form and I am not interested an during the invoicing as the database has the invoicing built in to expert level 8 and level 9 if someone would be able to help would be greatly appreciated

Hello everyone

I have discovered that the button with the macro that does the filtering same as VBA coding my new question is

In the extended cut on timesheet Richard shows you how to use some VBA code as you are able to just type in the time and the date defaults to the current day so if someone could give me the coding I'm looking for in the database and tell me how to get into the VBA editor as when I click on the button it comes up and macro builder start default

Thank you in advance.

Michelle

PS I know I'm asking other questions and Richard I'm hoping you will be able to help me with the problem with not knowing what to do to be able to work out my material costs way to change things from what was built an expert level 8
I want to stop using Excel for working out my costs and Richard F this means paying to get you to make me a video showing the changes that I need to make I'm willing to pay as we are able to adapt the orderdetail form and anything else that needs to b

Hello Richard

Things are not going but why I thought they were when I use the customer ID equals customer ID in the button yes that finds and filters that does not give you the next line weather name in it ready to enter a new time finish suggestions how to fix this when I don't know VBA coding or where to put it in if I'm able eventually get there when that open HELP