Filter records in a form

[CMontoro]

I've created a form with its subform to enter tasks of employees. however I need filter records only for active employees
The form has as a source, the table CARD_EMP (employee card). It has a field ST_EMP for the employee status (Active , Pasive)

In the Event Form_Current I wrote
DoCmd.ApplyFilter ST_EMP='A'

but it doesn't work

Thanks for advance
Carlos

 

[pbaldy]

Was my answer elsewhere not to your liking?