I have a form with 2 comboboxes (dept, section) and a listbox (employees).
Listbox is based on a query with 2 criteria (Forms!Form!Dep t and Forms!Form!Sect ion). 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!Sect ion Or Forms!Form!Sect ion Is Null - but when I save the query Forms!Form!Sect ion Is Null disapperars...
Am I doing something wrong? I'm working on Acc2000 - any suggestions?
Listbox is based on a query with 2 criteria (Forms!Form!Dep t and Forms!Form!Sect ion). 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!Sect ion Or Forms!Form!Sect ion Is Null - but when I save the query Forms!Form!Sect ion Is Null disapperars...
Am I doing something wrong? I'm working on Acc2000 - any suggestions?
Comment