SQL for Countries table is:

SELECT Countries.[Region ID], Countries.[Country ID], Countries.Count ry
FROM Countries


Can I use the following? - SELECT Countries.[Region ID], Countries.[Country ID], Countries.Count ry FROM Countries WHERE Countries.[Region ID] = strIN

Or is it more complex than that?

Thanks.

Hi all,

I was wondering whether somebody might be able to help me with a question I have on a MS Access Database I'm building.

I have created a search form with a few multiselect listboxes. What I'd ultimately like is for the selection(s) in one listbox to filter the second listbox, but am struggling to find a way to do this. I have looked at some of the other solutions on this forum but not been able to find one that...