Filters in Access 2000

[Guest]

I want to set up a filter on a drop down box so that when I select something
in one drop down box it will limit the list in the next drop down box. i.e to
add a new employee to my database I want to add their department and setion.
When I select the department, i want the next list to only show the sections
in that department and not the whole firm.
any help is appreciated.
Thanks

 

[Peter Hibbs]

Have a look at :-

http://www.fontstuff.com/access/acctut10.htm

HTH

Peter Hibbs.