My problem is quite hard to explain but here goes:
I have got two combo-boxes on a form both linked to each other, the second one is the one i want to use. Basically the user selects a field out of the first box which them filters the results in the other box. I then want the user to be able to once selected the result out of the second box to then go to the form where that record is based.
I have multiple forms based on one table with the information filtered out into the correct forms.

This is not too clear at the moment, i'll try to explain it better tomorrow. Any help though for now would be great. Thanks

Here's my two cents:

Why all those forms? I am guessing on this, but are these forms filtered by the same criteria you choose in that second combo? Say you choose Meat Products in the second combo and the form opens to show all Meat Products in this table (all forms on same table). If you choose Paper Products in the second combo, you goto a form that shows only Paper Products.

Am I on tract here, because if I am, you don't need all those forms, just one.

I think that by reading your question, you have a main combo which filters down as such first combe selects catagory ie, car, bike, boat, the second would the raffel down ie, if you chose car then would list makes of cars! Right?? if so as jwindon said why have so many forms?, it also sounds like you have all the records once opened in contiuous forms, hence the need to gotto the correct record!


I think that you would be better off haing one form to display the data if it only comes from one Table, hence will also make your desiging a lot easier!! http://www.access-programmers.co.uk/ubb/smile.gif

I think that by reading your question, you have a main combo which filters down as such first combe selects catagory ie, car, bike, boat, the second would the raffel down ie, if you chose car then would list makes of cars! Right?? if so as jwindon said why have so many forms?, it also sounds like you have all the records once opened in contiuous forms, hence the need to gotto the correct record!


I think that you would be better off haing one form to display the data if it only comes from one Table, hence will also make your desiging a lot easier!!

bad case of da ja vu going on here!, sorry for the duplicate reply!!!! :0 http://www.access-programmers.co.uk/ubb/redface.gif