hi have a differnt problem now
have a table with names of stars
have another table with star info like picture and biografie
and somhow i cant link them together
i want to dbl click on the name and open in the secend table the same name
i made forms of both table
i made a macro, and the second form opens but not on the same name

i don't now anything about vba so i dont now how to conect name to name

thanx

Send me an sample fo your date base in Access 97 and I do that for you before i send to you the base with the update.

hi
tried to post a sample
but each time i wanted to upload my computer crached
i can try to send it by mail to you
i only have hotmail

If your two tables have a field which is common to each other, ie Name.
You can use a button wizards third option to open specific data.