how is a tabbed form updated when another form alters the records

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

Guest

how is a tabbed form updated when another form alters the recordset - without
closing and re-opening the forms
 
It depends on how the form's set up.

If the various tabs simply refer to fields in the form's RecordSource, you
can requery the form:

Me.Requery.

If the tabs are actually subforms, you'd have to requery the appropriate
tabs:

Me!NameOfSubformControl.Form.Requery

Note that depending on how the subform is added, the name of the subform
control may be different than the name of the form being used as a subform.
 
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

Filter main form to records with no related records in subform,maintain updateable recordset 4
Need combo box to refresh when moving to new record 2017 1
Tab Form Coding 4
Refresh calling form 7
Not receiving forum emails 14
Open form and filter form & subform using combo-boxes 2
Automatically update a text field when any entry changed 3
open form to specific record number 5

Back
Top