Filter with double-click

[jean]

Hi

I have a continuous form containing 100 rows and 4 fields. One of the
field is named "EmpNo"

I want to be able to filter the form on a specific EmpNo when I
double-click it

I have try

Me.filter = Me.EmpNo
Me.filterOn = True

and it don't work

Can somebody help me ?

Thanks

 

[John Spencer]

Filters are strings. So try

Me.Filter = "EmpNo=" & Me.Empno

Or if EmpNo is not a number field

Me.Filter = "EmpNo=""" & Me.EmpNo & """"

I would name the control EmpNo to txtEmpNo to preclude confusion whether EmpNo
is referring to the control bound to the EmpNo field or to the EmpNo field itself.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County