filter records in a form

[cmweb via AccessMonster.com]

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

 

[mamumi]

Carlos,

Have you tried something like:

Private Sub Form_Load()
Me.Filter = "[ST_EMP]=""A"""
Me.FilterOn = True
Me.Recalc
End Sub

I'm using Access 2007, so I'm not sure if this syntax works for you.

mamumi

 

[Papa Jonah]

I have a similar quest.
Here is what I have tried and it does not seem to work. The bottom of the
form says "filtered" but I get every record instead of the "active" ones. In
the below code, I have tried "true" and "yes" for the checkbox and get the
same results.

Private Sub Form_Load()

Me.Filter = [chkActive] = True
Me.FilterOn = True
Me.Recalc

End Sub

Carlos,

Have you tried something like:

Private Sub Form_Load()
Me.Filter = "[ST_EMP]=""A"""
Me.FilterOn = True
Me.Recalc
End Sub

I'm using Access 2007, so I'm not sure if this syntax works for you.

mamumi

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

 

[cmweb via AccessMonster.com]

Hi mamumi
Your advice was the solution
Thanks a lot

Carlos