Clicking on name in list to move to that entry in a table

[Banaticus]

I've created a nice form for entering information into the record -- works for viewing the records as well. Here's the thing, in a traditional Rolodex you can somewhat see the names of nearby records. 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. See that mini table in the top left corner? I'd like to make it so that, when you click on a name there, the rest of the form changes to the corresponding information.

All of the rest of the form is 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, 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.

 

[Banaticus]

I thought that "Me" was a reserved keyword, like this.function/method, but now that I have that Me.Parent.Requery in the mini table's Current, when I try to load the whole thing I receive the error, "Access can't find the macro 'Me.' ... Note that when you enter the macrogroupname.macroname syntax in an arguement, you must specify the name the macro's macro group was last saved under."

I also built the form with the Microsoft Access wizard and do not know how to change the query in the main form. I'm also limited to using Microsoft Access 2000 -- how much of a difference is there?

 

[ghudson]

Me.Parent.Requery

That is a VBA command, not a macro. As Pat suggested, you must use the OnCurrent event [using the visual basic editor to use that command, not the Event properties field for that event].

 

[Banaticus]

Ok, in the mini table's OnCurrent property, it now has a VB expression saved there:

Private Sub Form_Current()
Me.Parent.Requery
End Sub

Edit: The above, when the form is opened, gives an "improper reference to parent object" error.

I'm still not sure how to "Change the query for the main form to include a reference to the list subform: Where StudentID = Forms!mainform!subform.Form!StudentID;"