How to create a query on lookup of multiple values

[ct2013]

Hi there,

I have attached a db with two tables.

I wanted to create a form where you can select multiple values from the table "years" and on a button it would open a query displaying all the records in "students" in those years selected.

Please help.:banghead:

Thanks

 

[pbaldy]

One way:

http://www.baldyweb.com/multiselect.htm

 

[ct2013]

Thanks, will take a look some time.

 

[ct2013]

Would you mind to have a go at mine as i am not the best at vba to run a query and i want mine to work off relationships that when i select year 07 and year 08 from the table "years" it will pull up all the records in "students with that criteria.

Thanks