Form : Query button not function

[suzeq]

Hi,

1) I have Form QuerByID to query training record by entering EmpID unfortunately it was not function.
2) I have Form QueyByProcess by choosing process unfortunately it wasn't function to.

Could anyone help me....

[ranman256]

change the row source for the combo box
SELECT DISTINCT QueryByProcess.ProcessName
FROM QueryByProcess;


In the combo Combo308 afterupdate event delete the exising macro, change it to Event procedure,
in the code block , paste this:

me.filter="[ProcessName]='" & Combo308 & "'"
me.filterOn = true

[suzeq]

Hi,

I have change it but it still wasn't reflect into my record field, it has happened to all my form..

here my latest attachment after try above coding

rgds