Combo Box Go To Record

[jereece]

I have a table called "Report1" which has 3 primary fields (WORK_ORDER_NBR, WORK_ORDER_TASK, and TASK_CAT_VALUE) as well as other data. I have a form called EHS_EVAL with "Combo Box 1". This combo box SELECT DISTINCTROW for the 3 primary fields. What I want is to have in the combo is when someone clicks on an item in the list, the form moves to that record. How can I make this happen in an event procedure?

I appreciate your help.
Jim

 

[Fuga]

If you design the combo with a wizard, this is one of the options.

Fuga.

 

[PMrider]

in the ON CLICK event procedure of your combobox add

DoCmd.ApplyFilter, "[yourfieldname] = Forms![yourFormname]![Comboboxname]"