Refreshing a form - automatically

[Iain]

How do I get a form to automatically refresh once (not continually using a timer).

The scenario I have uses a parent table and a child table.
(thanks to mmcarthy for indicating better termenology than I was using)
I have a main form that displays one page per parent record and all the related child records in a sub-form.
I then have a second form from which I can select records to be added (appended) to the child records. When the second form closes a query appends selected records to the child table. The problem I cannot solve is to get the main form, in particular to sub-form section, to update (refresh) automatically after I close the second form.

thanks
Iain

[MMcCarthy]

In the On Close (Button click or whatever) event on the second form put the following code. Be careful of the subform name, check the name under the Properties in the Other tab.

[CODE ]

Forms("NameOf ParentForm")![SubformName].Requery

[/code]

How do I get a form to automatically refresh once (not continually using a timer).

The scenario I have uses a parent table and a child table.
(thanks to mmcarthy for indicating better termenology than I was using)
I have a main form that displays one page per parent record and all the related child records in a sub-form.
I then have a second form from which I can select records to be added (appended) to the child records. When the second form closes a query appends selected records to the child table. The problem I cannot solve is to get the main form, in particular to sub-form section, to update (refresh) automatically after I close the second form.

thanks
Iain

[MMcCarthy]

Sorry the CODE indicators shouldn't be showing

In the On Close (Button click or whatever) event on the second form put the following code. Be careful of the subform name, check the name under the Properties in the Other tab.

 
Forms("NameOf ParentForm")![SubformName].Requery
 
 

[Iain]

Thank you very much.

I had got close to the solution but had not realised that I must direct the requery command.

Iain