Dec 22 2018 01:36 PM
So, I have a value (text) in a form, that was generated from multiple selected list. e.g. the text box says, 'AB1' or 'CD2' or 'EF3'
I want to pass this value ('AB1' or 'CD2' or 'EF3') to a query field (e.g. customer). Well, I can see that the text can come over, but it is not behaving in the criteria section. I can hand type 'AB1' or 'CD2' or 'EF3' in the criteria and the query will work, but when drawing the value from the form, it will not filter. Why? I did a simple expression, expr1: [Forms]![FormName]![Field] and it display exactly as 'AB1' or 'CD2' or 'EF3' . Why can't it filter in the criteria?? Help!! Thanks in advance.
Sincerely,
Perry
Dec 22 2018 02:33 PM
someone please help. I thought this is just a brain freeze on my side. Thank you
Dec 23 2018 09:58 AM
Dec 31 2018 01:37 AM
Great, I'm glad to hear you worked it out.