I have 3 combo boxes on a form. The form is bound to table EQUIPMENT which has fields EQType_ID, Make_ID, and Model_ID among others. The first combo box is called cmbo_EQType_ID w/ Control source EQType_ID. Its row source is SELECT EQType.sys_id, EQType.Equipment_Type FROM EQType ORDER BY [Equipment_Type]; . It works fine. The second combo box is called cmbo_Make_ID w/ control source Make_ID. Its row source is SELECT Make.sys_id, Make.Make FROM Make ORDER BY [Make]; It works fine. The third combo box is called cmbo_Model_ID w/ control source Model_ID. It has no row source. The idea is that once a type (PC, Laptop, printer, etc) is selected, and a Make is selected (Hp, Compaq, DEll, IBM, etc) then the 3rd drop down is filtered by the first two. So I put an ON CLICK event on the second combo box that enables combo box 3 and sets it's row source to be the following: SELECT Model.sys_id, Make.Make, Model.Model FROM Model inner join MAKE on Model.make_id = make.sys_id WHERE (((make.sys_ID)= Make_ID) and (model.EQType_ID) = EQType_ID) ORDER BY make.make, Model.Model; I did this because setting the 3rd box's row source in the object causes it to err out when I open the form & before I select a value in the first two boxes. This works fine. However, the WHERE statement does not appear to be working, as the 3rd box drop down list has all values, and not those that are depended on the values of box 1 & 2. I've tried various WHERE statements like these to no avail: Where (((make.sys_ID)= [me].[Make_ID]) and (model.EQType_ID) = [me].[EQType_ID]) Where (((make.sys_ID)= [me].[cmbo_Make_ID].[value]) and (model.EQType_ID) = [me].[cmbo_EQType_ID].[value]) I just keep getting prompt dialog boxes for values for the unidentified "[me].[cmbo_Make_ID].[value]" Anyone have an idea how to fix this? Help! Thanks. - Pete <blocked::blocked::mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]
[Non-text portions of this message have been removed]
