filter problem

[masoud_sedighy]

Hello



I like to filter my form based on data is available in control source of unbound text box.


So in my form I have some fields like:

Id
Date
Title
Start date
Due date
Overdue

For filtering other fields (bound text box) there is no problem. But for overdue field (unbound) I have problem.


Expression of control source overdue text box is: IIf(Int([Due Date])<Int(Date()),"Overdue")

Part of macro expression for search button click is: [TempVars]![strFilter] & " OR ([overdue] Like ""*" & [TempVars]![strSearch] & "*"")"

Now when I click search button I received message “enter parameter value”

Best regards.

[orange]

What is the purpose of this?

Expression of control source overdue text box is: IIf(Int([Due Date])<Int(Date()),"Overdue")

Are you trying to see if the record is Overdue?

Such is the DueDate < today's Date?

Iif (Datediff("d",Date(),[Due Date])< 0 ,"OverDue")

Just a comment on field names - You should avoid spaces and special characters in field names.

[masoud_sedighy]

thanks.
i made query and used expression property of unbound text box in that (new field). so i used record source of my form with this query, now i could filter my form.

best regards.