ms access 2010
1 TopicHelp with Query Criteria
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, Perry1.5KViews1like4Comments