All filter in Combo box

[Tupacmoche]

I have an sql linked table that has a bit column used to indicate that a job is complete. The default value is always 0 (zero). On the front end there is a check box control to change the row to complete. Since, the only time both choices are available is when records are complete, I set up a table like such: See attached picture

The row source for the Combo box is this sql query:

SELECT tblComplete.Description, tblComplete.Complete
FROM tblComplete;

So, I can select Complete which is 'Yes' and Incomplete which is No, I should mention that the second column is bound. But, when I select All which is * , I get Run-time error 3075. Syntax error(missing operator) in query expression'(Complete) = *'.

Clearly '*' is not a value in the table, only -1, and 0. So, how can I resolve this and get all values?

 

[CJ_London]

depends on what you are doing - if you have code to filter a form, then don't filter for '*'.

if a query that references the form

WHERE completed=forms.myform.completed or forms.myform.completed ='*'

Note that with your current setup you are mixing datatypes - bit is a number type, * is text

 

[pbaldy]

Curious if that will work CJ. Might though. My first thought was deleting the * and leaving the field Null, and using this:

http://theaccessweb.com/queries/qry0001.htm

Your thought uses a similar concept so maybe it will work. Just caught me off guard.

 

[CJ_London]

@Paul - you are right, I alluded to it, but should have said, change * to null