Choosing records to view, like a hyperlink

[mattpearcey]

I have seen a database, made in access, that through a choice of design, they have got the records all to be on show based on a few slections of drop downs. Then the records act as hyperlinks to bring up other forms with data specific to them. Much like a internet site does. So, my example is, i selct from a few options on the form to show all banks in the Middle East. It will then show all of these on the form, as hyperlinks, with possible a little bit of data next to each. Then i want to be able to double click on these to open up forms that are more specific on that bank.

Ive seen it done, and im sure it is pretty straigh forward, but i would love some help getting it going.

anyone? Thank you for your help already.

Matt Pearcey

 

[SyedAqif]

Have u tried Hyperlink method? n then choosing named location in file?

Cheers!
Aqif

 

[mattpearcey]

yep - tried it but i want it to be filtered to the record that i click on. which i cannot get to work. it just opens up the form, as is. So, from the first record. which not good. any other ideas? i am thinking of a macor to pull up the form, with a filter, but cannot get the macro right Thank you for your help already.

Matt Pearcey