Yes/No Field Problem

Yes is -1 in Access, although True (without quotes etc) should also work. As indeed should Yes.

EDIT

Another thing - you should put the field names in [ ] brackets when performing a VBA function on them:

SELECT CAMERA_ID, RTRIM([MAKE]) + ' ' + RTRIM([MODEL]) AS CAMERA, ENABLED
FROM CAMERAS
WHERE (ENABLED = -1)
ORDER BY CAMERA

Thanks for your help.

After much messing I realised the error was caused by the ORDER BY statement. Got that sorted and it all worked.