auto update of a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subform Data Entry Setting 0
Updating tables when you input new data 0
Parameter Value error in a Subform 0
Subform Requery Criteria 1
Move to Next Subform 5
Add form with subform not working 3
Subform record coordination 2
form/subform-require at least 1 new subform record at data entry 1

Back
Top