I'm very new to access and need some help with a search form. My database is used to track cargo information arriving and departing on trucks. On my search from there is a checkbox that indicates if the truck has Hazardous material(HazMat) or not. If checked my query returns all the records with hazmat. if unchecked it returns all records without Hazmat. How do I tell access that when unchecked to return ALL records?
My query criteria is =[forms]![Frm_InboundTruckSearch]![HazMat].
My table is "Tbl_InboundTruckLog"
Search form is "Frm_InboundTruckSearch"
The Feld on the Search from and table is "HazMat"
I hope this is enough info for someone to tell me what I'm doing wrong. Again I'm really new to access so I'm hoping this is an easy fix I just don't see.
thanks