I use a form with 2 subforms embedded.  One form I use to enter data and the 
other I use to view previously entered data.  My data entry form has a "new" 
record button that I want to get more use out of.  #1 - I want to be able to 
UPDATE the form that displays data using an OnClick function.  #2 - I want to 
be able to have it then go to a specified field entry box.  My main concern 
is updating dynamically the information displayed in the other subform.  How 
do I go about doing this?

Hi Jeff

You can update a control on a subform with 
[Forms]![MainFormName]![SubformName].form![ControlName].requery

Change
MainFormName
SubformName
ControlName
to what you use on your form(s)

You can also go to a control by using SetFocus

All of these can be used OnClick, AfterUpdate (of a control on the main 
form), etc, etc

Hope this helps


-- 
Wayne
Manchester, England.



"Jeff @ CI" wrote:

> I use a form with 2 subforms embedded.  One form I use to enter data and the 
> other I use to view previously entered data.  My data entry form has a "new" 
> record button that I want to get more use out of.  #1 - I want to be able to 
> UPDATE the form that displays data using an OnClick function.  #2 - I want to 
> be able to have it then go to a specified field entry box.  My main concern 
> is updating dynamically the information displayed in the other subform.  How 
> do I go about doing this?