auto update of a subform

J

Jeff @ CI

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?
 
W

Wayne-I-M

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
 
Top