Update datasheet subform on Save

[tjones]

I have been moving my information onto Tabs to concentrate the "type" of information in one place rather than having one very long form.

On the Main Form-Contact Info tab there is an Address button (and below that a datasheet display only subform). The cmdbutton opens the Address form. Once the information is changed on the address form how do i code it so that the information is also updated in the datasheet view only subform on the contact tab when selecting the Save button on the Address form? The datasheet subform information is obtained for display using a query (qryAddrSub)

The Macro behind the Save button on the Address Form and the two forms are displayed in the graphic.

The problem is coming from moving a cmdbutton from the main form that opened the address form onto the tab containing that information and adding the view only datasheet subform for "at a glance", the information displays when you open the main record but when you update a record you have to leave that individuals complete record and go back in before the subform updates.

 

[pbaldy]

You can requery the subform behind the "Save" button on the Address form.

 

[tjones]

I keep trying to get it to work in the Macro but I can't seem to figure out what command and how to set it up.

Requery (command is easy enough but)

Control Name _____ is where i run into problems.

I have tried
Requery: [qrySdtAddr] but it just gives me an error.
also where in the lineup it should go.

 

[pbaldy]

You'd need the full reference to the subform:

http://www.mvps.org/access/forms/frm0031.htm