Multi-Value filter - Error 3831

[PatAccess]

Hello All,

I've tried reading a few other threads on this subject but I just don't get it and I need help please.

I have a form with a multi-value field called BuildingList.
I also have a search form with a cboBuildingList and a cmdBuildingList.
I would like to a form where BuildingList is equal to cboBuildingList and it is giving me an error 3831 (The multi-valued field 'BuildingList' cannot be used in a WHERE or HAVING clause)

Here is my code:
DoCmd.OpenForm "Frm_Assessment", acNormal, , "BuildingList='" & Me.cboBuildingList.Column(1) & "'"

The other thread talked about Me.filter and I just don't understand it. Can someone please help me? :banghead::banghead:

Thank you

 

[isladogs]

Multivalue fields do not behave the way you expect & are best avoided
They have many limitations

Have a read of this thread:
http://www.utteraccess.com/forum/Multi-Fields-Evils-Lo-t1991337.html

 

[CJ_London]

multi value fields are a PITA but if using them, you need to refer to the value

"BuildingList.Value='" & Me.cboBuildingList.Column(1) & "'"

but using one implies the bound value will be numeric (typically an autonumber pk) whereas you are looking for a text value.

Perhaps you are not, but just be aware.