I have a form with 2 comboboxes (dept, section) and a listbox (employees).
Listbox is based on a query with 2 criteria (Forms!Form!Dept and Forms!Form!Section). Whenever I choose values in both comboboxes listbox works fine. But how can I make section criteria optional i.e. when choosing dept I would see all the dept's employees, and when I need to choose section the list would get shrinked to just the section's employees.
I've tried (according to MSKB) Forms!Form!Section Or Forms!Form!Section Is Null - but when I save the query Forms!Form!Section Is Null disapperars...
Am I doing something wrong? I'm working on Acc2000 - any suggestions?