This is the code of the row source in the code,"SELECT [qryinduction].[Model] FROM qryinduction;
This is the code afterupdate event,"Action(SearchforRec
ord) then in where condition ="[Model] = " & "'" & [Screen].[ActiveControl] & "'"(I would like the in active controls to be grayed out)
This code will work in the first two dropdowns. but after that I get an error saying Data type Mismatch. Below is the database. It includes the form query and table.
(I would like the inactive controls to be grayed out) when you select the model.