Search by derived field.

[Plink]

hi, im hoping someone can help.

i have a database with a derived field. It shows whether my record is
active/expired based on a date calculation.
Here is the statement attached to the unbound text box.
=IIf([ActiveFrom]+365>Date(),"Active","Expired")

Im having trouble using this data. I need to be able to search by
active/expired records, along with 4/5 other search fields. Here is an
example of my other search strings.
If Not IsNull(Me.Surnamebox) Then
strWhere = strWhere & "([Surname] Like ""*" & Me.Surnamebox & "*"")
AND "

Everything goes sweetly, the text box works, my other searches run, but any
time I try to combine the two, it just isn't goin for me. Can someone advise?

Thnkyu.

 

[Plink via AccessMonster.com]

Here is a section of the code for my search, Id appreciate it if someone
could suggest something

If Not IsNull(Me.cboMemberType) Then
strWhere = strWhere & "([Member Type] Like ""*" & Me.cboMemberType &
"*"") AND "
End If

If Not IsNull(Me.cboMemberStatus) Then
strWhere = strWhere & "(=IIf([ActiveFrom]+365>Date(),"Active",
"Expired"") AND "
End If

 

[Plink via AccessMonster.com]

Bumping this thread in the hope someone could help thanks