var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Basing a combo box, on the result of another combo box
I have 2 tables, supplier and supplier contact.
One supplier can have many contacts (employers)
On my form, I want the user to be able to select the suplier, and in the second combo box, I only want it to display the workers for that employer.
If I select Microsoft in the first combo box, in the second, I only want Andy and James to be avalaible in the list.
Look at "DemoSupplierEmployersA2003.mdb" (attachment, zip).
Look at Form (VBA), Query, Tables, Relationships.
Open Form and try. Adapt it in your mdb.
Thankyou very much, I will have a look at that when I am on a diffrent computer and can open .zip files and will let you know if it has solved my problem.