Recordset Filter With Tick Box Yes/no

bogushs

Registered User.
Local time
Today, 14:30
Joined
May 4, 2005
Messages
27
Hi There

Im Trying To Find A Solution To My Problem About Searching Records Through A Recordset Filter. I Have Performed The Follwing Code To Filter My Records From The Combo Box However In My Database I Have Several Yes/no Fields That I Would Like To Filter Out As Apart Of A Recordset.

Code is

Dim sql As String
sql = "SELECT * FROM [qry Landuse Survey 2005] WHERE [STREET] = '" & Me![Combo255] & "'"
Me.RecordSource = sql


Does Anyone Know How I can use the same principle for Yes/no Field Types?


Comments Much Appreciated!
 
How does this sit in conext of code?
 
Something like this but it should give you an idea where to start...

sql = "SELECT * FROM [qry Landuse Survey 2005] WHERE [YourYesNoField] = -1"
 
Thank you very much! Works like wornders


Cheers :)
 

Users who are viewing this thread

Back
Top Bottom