Refreshing Data

I am new to writing code, so this is one of many baby steps.

I am using VB Express 2005, with a Sql Express 2005 database. I have 2 joined tables, and I have made a form that displays data from the parent table. The same form displays data from the child table.

The problem I am having is that when I navigate to new records using the BindingNavigator, the child data is not refreshed. I wrote code that refreshes it, but when I execute it on the navigation events, the refresh code runs before the navigation event, so it pulls data from the record I am navigating from, not the record I am navigating to.

If I execute the refresh code using a button click event, it works fine.

How can I refresh the data for the new record that I am navigating to. There must be an easier way. Thanks.

[819 byte] By [jlave] at [2008-1-5]