True/False Fields

[MS_Access_Amature]

In my Employees table i have a Yes/No field named [Active].

I'm trying to make a ComboBox that allows you to select view Active, Inactive, or All employees. How do I do the All part,?

Active:
Me.RecordSource = "SELECT * FROM Employees WHERE [Active]= True"

Inactive:
Me.RecordSource = "SELECT * FROM Employees WHERE [Active]= False"

All:
Me.RecordSource = "SELECT * FROM Employees WHERE [Active]= ???"

 

[boblarson]

Active:
Me.RecordSource = "SELECT * FROM Employees WHERE [Active]= True"

Inactive:
Me.RecordSource = "SELECT * FROM Employees WHERE [Active]= False"

All:
Me.RecordSource = "SELECT * FROM Employees "

 

[MS_Access_Amature]

Wow...so simple. Lol . Thanks Bob!

 

[boblarson]

No problem.