View Single Post
  #1  
Old May 28th, 2010, 01:05 AM posted to microsoft.public.access
ac512
external usenet poster
 
Posts: 40
Default Multiple selection filter - any help appreciated

Hello

I am using Access 2007, & have a table which I use as a look-up table to
filter data in another table.
My 'look-up table' has 2 fields, & altough the combination of these 2 fields
are unique, there are duplicate values in each of the fields. As an example:
Field1 Field2
A 1
A 2
A 3
B 1
B 2
In my filter, I will have to consider a selection made from both Fields in
my table.
I would like to set up a form, so that the user can select multiple field
combinations to filter data in another table.
Can anyone make any recommendations on the best approach.
I hope this makes sense!
Any assistance/advice would be greatly appreciated

Thanks very much in advance
Kind regards
AC