Problem with form display says error,"Data mismatch".

This is the code of the row source in the code,"SELECT [qryinduction].[Model] FROM qryinduction;

This is the code afterupdate event,"Action(SearchforRecord)   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.
CheckMark.accdb
gigifarrowAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
remove the Control Source of the combo box, make it unbound (no Control source)
GMail2.accdb
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.