Changing Focus on Form in Datasheet View not Updating SubForm

[JJinPA]

I'm new to Access VBA programming but have been programming in ASP.NET for years. I think I'm missing something simple.

I have a form called frmContacts that comes up in datasheet view. It lists multiple contacts. I have two subforms, also in datasheet view, for phone numbers and e-mail addresses.

All forms are linked Master/Child on ContactID.

When I click on a row in frmContacts, I expect the subforms to update to the phone and e-mail addresses associated with the new ContactID of the row that has focus.

Does it not work this way? Am I missing something?

I also tried using a Form.Requery on the GotFocus event, to no avail.

Any ideas or concepts would be greatly appreciated. Thanks!

 

[wiklendt]

does sound liek you're missing something simple.. are you able to post a sanitised version of the database? i can't think of what might be missing off the top of my head. i have many forms doing exactly what you describe...