How do I create Access 2007 dynamic Combo Box
Posted on 2011-02-26
I have a Table "Mojo" fields Dept, SampleType and Sample. Table "Dept" fields: Dept and DeptDesc. Table "SampleType" fields: SampleType and SampleTypeDesc. Table "SampleInfo" Fields: SampleName, SampleType, Dept. Access 2007 is front end and SQL server 2005 back end. I created a Form Mojo with a Combo Box for Dept that would select Dept and Combo Box for Sample Type to select Sample Type and I want to create a Combo box that would display SampleName field from SampeInfo table to feed into Sample Field of Mojo table. How can I do this?