I currently have a form where I select from a combo box on a building location. My query then reads Like [Forms]![Form_Distribution_Selection_Criteria]![Building]
This returns the building I selected in the combo box. I would like to change from a combo box to a list box so I can select multi fields. I know how to change to a list box with Multi Field option checked. My question is this, What would I need to change my formula in my query to in order to pull multiple selections from my list box choices? Currently it reads:
Like [Forms]![Form_Distribution_Selection_Criteria]![Building]
This returns the building I selected in the combo box. I would like to change from a combo box to a list box so I can select multi fields. I know how to change to a list box with Multi Field option checked. My question is this, What would I need to change my formula in my query to in order to pull multiple selections from my list box choices? Currently it reads:
Like [Forms]![Form_Distribution_Selection_Criteria]![Building]