Requery Subform From Another Form - Access TechHelp


	Back to Access TechHelp Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Requery Subform From Another Form

Joel LaBo

3 hours ago

I have a main menu form that has a tabControl (named TabMain). the tab Control has 7 pages.  Page 1 has a subform showing the list of boarding arrivals to check in that day.  My user double-clicks on the particular boarding reservation when they arrive, which opens a popup form to complete the check-in process.  When the check-in is complete, I am trying to requery that subform in Page 1 of the tab control. I do not get any error msg, but the subform is not refresh.  Is there a limitation because the subform is in a tab control?

Main form:  frmControl
TabControl: TabMain
Tab Page1:  TabBdArrivals
Subform:    SubBdArrivals

Here is the syntax:

'-- If Form "frmControl" is Open: Requery SubForms.
    If CurrentProject.AllForms("frmControl").IsLoaded Then
       ' Return Control object pointing to a combo box.
             Forms!frmControl.SubBdArrivals.Requery
    End If

	Joel LaBo OP @Reply 3 hours ago

Donald Blackwell @Reply

2 hours ago

Joel

Did you try requerying the form in the subform instead of the control itself?

Forms!frmControl!SubBdArrivals.Form.Requery

Tab Controls can make the connection goofy sometimes. I've been able to do requeries before just as you've typed and I've had to go through the entire hierarchy Form!FormName!SubFormControl.Form!TabControlName!PageName!SubFormControlName.Form.Requery. I've never pinned down what makes Access behave differently, though I suspect it's environmental - such as version, etc.

Richard Rost @Reply

95 minutes ago

Donald has it. The tab control itself isn't the limitation. The important part is that SubBdArrivals is the subform control on frmControl, and the actual form loaded inside that control is its .Form property.

Try:

Forms!frmControl!SubBdArrivals.Form.Requery

Also, make sure "SubBdArrivals" is the name of the subform control, not just the name of the form object used as its Source Object. Those are often the same name, but they don't have to be.

If that code is running from the check-in popup, I'd put it right after the record is saved, or in the popup's Form_Close event if the check-in is always complete by then.

Plus, as everyone knows, I'm not a huge fan of tab controls. I prefer changing a subform's SourceObject property. But that's just me.

Next Unseen

New Feature: Comment Live View