G Guest Mar 31, 2006 #1 I want to select a either records with a specific "team member" based on a combo box or all team members if the combo box is left blank
I want to select a either records with a specific "team member" based on a combo box or all team members if the combo box is left blank
M Marshall Barton Mar 31, 2006 #2 mikeycan said: I want to select a either records with a specific "team member" based on a combo box or all team members if the combo box is left blank Click to expand... SELECT * FROM thetable WHERE [team member] = Forms!theform.thecombo OR Forms!theform.thecombo Is Null
mikeycan said: I want to select a either records with a specific "team member" based on a combo box or all team members if the combo box is left blank Click to expand... SELECT * FROM thetable WHERE [team member] = Forms!theform.thecombo OR Forms!theform.thecombo Is Null
