Opening specific form when clicking cell in table

[Alog55]

Hi

I am looking for a way, to open a form related to a table cell. Consider the following table:



Say i click Country B. I then want a form to open with information regarding that country. The same goes, if I click one of the cities.
Is this possible in any way?

Thanks!

Country	City 1	City 2	City 3
Country A	City A	City B	City C
Country B	CIty D	City E	City F
Country C	City G	City H	City I

[pbaldy]

Is this what you're after?

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

hopefully you aren't storing data that way:

http://r937.com/relational.html

[Missinglinq]

Note that Paul's excellent tutorial is talking about clicking on a Control in a Form which is based on a Table...which is how this must be done! You cannot do it clicking on a Cell in a Table itself.

Also note that you really, really, really need to take the time to read the article on Relational Databases/Normalization that he gave you a link for! Your displayed example is grossly flawed and will cause you constant problems, in accomplishing even the simplest tasks.

Linq ;0)>