Sophie has attended:
Access Introduction course
Access Intermediate course
Subcontractor Database
I am trying to create a form so that i can have a drop down box for trade description and then a second one for subcontractor, i want the subcontractor box to filter from the trade above, so if i select bricklayer from the trade description drop down, then only the bricklaying subcontractors are available for selection in the subcontractor drop down?
RE: Subcontractor Database
Hi Sophie, thanks for your query. There's a template to do just that here:
http://blogs.office.com/b/microsoft-access/archive/2009/04/03/template-demonstrates-how-to-synchronize-combo-boxes.aspx
...but be warned, it is fiddly and involves either macros or VBA.
Hope this helps,
Anthony