form filter with more than one parameter

  • Thread starter Thread starter iccsi
  • Start date Start date
I

iccsi

I would like to fiter my form using filter property.
It seems only work for one parameter.

My filter is like following:

EmployeeID = [forms]![frmEntry]![EmployeeID] and Start = [forms]!
[frmEntry]![EIS subform]![txtStartDate]

It works only I have first parameter, but not for 2 parameters.

Can you plase advise where I am wrong?

Your help is great appreciated,
 
Try it like this --
(EmployeeID = [forms]![frmEntry]![EmployeeID]) AND (Start =
[forms]![frmEntry]![EIS subform]![txtStartDate])
 
Try it like this --
   (EmployeeID = [forms]![frmEntry]![EmployeeID]) AND (Start =  
[forms]![frmEntry]![EIS subform]![txtStartDate])

--
KARL DEWEY
Build a little - Test a little



iccsi said:
I would like to fiter my form using filter property.
It seems only work for one parameter.
Click to expand...
My filter is like following:
Click to expand...
EmployeeID = [forms]![frmEntry]![EmployeeID] and Start =  [forms]!
[frmEntry]![EIS subform]![txtStartDate]
Click to expand...
It works only I have first parameter, but not for 2 parameters.
Click to expand...
Can you plase advise where I am wrong?
Click to expand...
Your help is great appreciated,- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thanks for helping,
Is it possible to have parameter optional?
For example, if EmployeeID dropdown is empty then the parameter is
null and the form gets all records.

Thanks again,
 
(EmployeeID = [forms]![frmEntry]![EmployeeID] OR
[forms]![frmEntry]![EmployeeID] IS NULL)
AND (Start => [forms]![frmEntry]![EIS subform]![txtStartDate] OR
[forms]![frmEntry]![EIS subform]![txtStartDate] IS NULL)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


inungh said:
iccsi said:
I would like to fiter my form using filter property.
It seems only work for one parameter.
Click to expand...
My filter is like following:
Click to expand...
EmployeeID = [forms]![frmEntry]![EmployeeID] and Start = [forms]!
[frmEntry]![EIS subform]![txtStartDate]
Click to expand...
It works only I have first parameter, but not for 2 parameters.
Click to expand...
Can you plase advise where I am wrong?
Click to expand...
Your help is great appreciated,- Hide quoted text -
Click to expand...

- Show quoted text -
Click to expand...

Thanks for helping,
Is it possible to have parameter optional?
For example, if EmployeeID dropdown is empty then the parameter is
null and the form gets all records.

Thanks again,
 
Back
Top