SQL for the day

[mjdemaris]

Ok, the problem is: I have a check box in a datasheet that does not show if the value is true or false - when the SQL (vba) is set as the record source.

The DS opens as a sub form, and within a Navigation form. The loading record source is a query. This works fine.

When I use a text box to type in search criteria (like find as you type, on change event - values passed to SQL in separate module, set a global variable, which is then set as the record source), the other fields show up fine, but not the check boxes, they are just black boxes.

Thoughts?

 

[CJ_London]

does the checkbox have a valid controlsource which is either true or false (i.e. not null)?

 

[mjdemaris]

Yes, it has a valid control source. The table's default value is set to "no". The form's default is not set.

 

[AccessBlaster]

On the sub form go to the record source, click the (...) open the query. Right click to show SQL view, then copy and paste SQL here.

 

[mjdemaris]

Ha ha! I was making some changes a while back and added another field in another table and the form is confused! So was I until I checked BOTH table and query!
Solved this one!