Filter a continuous Form using data from two fields

[scoe]

Hi, I hope someone can solve this for me.


I have two fields, [Faculty] and [Faculty2] in a continuous form both holding a different faculty or the second field [Faculty2] remaining empty... I need to be able to filter all records with, say, science, irrespective if it is in [Faculty] or[Faculty2].

At the moment I have a combobox which will successfully filter one or other field but not look at both and I'm not sure how to handle this, I was looking at an IIf statement but cannot get it to work.

Code I have at present:

[Me.Filter = "[Faculty]=" & Chr(34) & Me.Combo100 & Chr(34)
Me.FilterOn = True]

Any support would be greatly appreciated, thank you

Sara

[azhar2006]

Hello
Look at this example
Is it what you're looking for
https://www.accessforums.net/sample-...box-45548.html

[scoe]

Hi
Thank you but no
Using the example below, if I was looking for Technology I would want Records: Org/48 and Org/49 to be filtered out.... Hope that is a little clearer.

OrgID	Faculty	Faculty2
Org/47	Creative & Professional Studies	Science
Org/48	Technology	Science
Org/49	Creative & Professional Studies	Technology

[scoe]

Thank you for your help, I have sorted it by using a parameter query as my filter.