Updating data from one sub form to another

[REDaughdril]

First, I thank all of you for taking time to help!

I have a form that has a tab control sub form, in tab # one I have name/address demographic, in the other tab sub forms I want to use the name field from tab # one sub form (helps to keep them focused) I use unbound field in some cases to display the data from the first tab sub form (=[Forms]![BaseForm]![frmtab#onesubform].[Form]![strLastName]) others I use queries.

The problem I have is that the data is not updated unless I go back and forth between records on the main form.

Is there a command that will update the data without making be go between the main records? Or should I be doing something different?

Again thanks for all the help!

 

[Jack Cowley]

In the Tabs On Change event use code like this:

Me.NameOfSubformToRequery.Requery

When you move from Tab1 to Tab2 by clicking on Tab2 the subform on Tab2 will be requeried.

hth,
Jack