View Full Version : Clicking on name in list to move to that name in other table


Banaticus
01-31-2006, 10:11 AM
This would probably fit better under the macro folder.
http://i9.photobucket.com/albums/a66/bubbajoe12345/workspace.jpgI've created a nice form for entering information into the record -- works for viewing the records as well. That top left corner window? It's just sitting there, not linked to anything else. I put it there because in a traditional Rolodex you can somewhat see the names of nearby records. You know how far away a name is, you can see tabs for "A", "C", etc. With this form as is, when using the arrows at the bottom to move around in the records, you can't really be sure how far away the name you're looking for is. How many "C..." names will you have to click through to get to a "D..." name? Who knows, you can't see how "thick" the "C..." section is. So, I'd like to make it so that when a name in the top left corner is selected, the main part of the form changes to the corresponding information. This will change the rest of the form as that is already working fine.

See, the three subforms and the main part of the form are linked through social security number. When a new person is chosen in the main body, all of the other tables change to reflect his information. Except for that single table in the top left corner. That table is unliked to the other tables and is merely sitting there on the form right now.

So, how can I link them such that selecting a name from that top left corner will change the person in the main body of the table (and thus change the other tables)?

While I'm asking things, what's involved with turning this form into one of those Database Web Page things?

Thanks for all of your help, everyone, I wouldn't have made it this far without you.