Yes/no checkbox how to default to Yes

[rjmcl]

Be gentle with me, for I am new, I can't write code, my database is all done by macros etc.

I have created a subform which incudes a yes/no checkbox. I want this to default to 'checked'. The subform is used to record an audit of the position of valves. It is based on a query combining two tables, one containing valve details and the other the results of the audit. I have set the default value for this field as '-1' in the audit results table, and also in the subform checkbox field.
However whenever the query is run, the subform contains a list of valves with thier checkboxes stubbornly unchecked. How can I make the query return a list of valves with the checkbox ticked?

Thanks
Richard

 

[ColinEssex]

Set the default value in the control properties.

Col

 

[rjmcl]

Already done that!
The control default is already set to "-1" on the subform, but still displays a list of unchecked boxes when the form opens. Is the fact that the subform is seen in datasheet view relevant?
Richard

 

[jrjr]

Instead of -1 try Yes

 

[Rich]

The control will only set the checkbox to True when you add new records, do any of your existing records contain a True value?