form filter with more than one parameter

[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,

 

[KARL DEWEY]

Try it like this --
(EmployeeID = [forms]![frmEntry]![EmployeeID]) AND (Start =
[forms]![frmEntry]![EIS subform]![txtStartDate])

 

[inungh]

Try it like this --
   (EmployeeID = [forms]![frmEntry]![EmployeeID]) AND (Start =  
[forms]![frmEntry]![EIS subform]![txtStartDate])

--
KARL DEWEY
Build a little - Test a little

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,- Hide quoted text -

- Show quoted text -

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,

 

[Douglas J. Steele]

(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!)

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,- Hide quoted text -

- Show quoted text -

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,