Refresh nested subforms

[Peter Stone]

I'm a novice.

I have a combo box (Destination) on the header of the form (Textform) that
selects records that are displayed in text boxes in 2 nested subforms.

When I select a new record, two other fields, from the record that I display
on the header of the form, refresh immediately. The fields displayed in the
nested subforms don't refreash until I select Records/Refresh from the menu.

The nested subforms are on a tab page.

The joins between the tables appear OK: same names and data type for the
Master/Child fields. The relationships between the tables also appear OK.
I ticked "Enforce referential integrity" and "Cascade update related fields"
in the Edit Relationships box

I suspect there’s a simple answer. But here's some relevant info from the
tables if it helps.

Table: GlobalDestinations
Key::GlobalDID
This field selects the country name from a list
Field: CountryName
Data Type: Text
Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT CountryCodes.CountryName FROM CountryCodes ORDER BY
CountryName;
Bound Column: 1
Column Count: 1
All other fields are text
This table is connected (1 to many) to

Table: GtDestinations
Key::GtDID
This field joins the tables using the country name
Foreign Key: GlobalDID
Data Type: Number (long integer)
Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT GlobalDestinations.GlobalDID,
GlobalDestinations.CountryName FROM GlobalDestinations;
Bound Column: 1
Column Count: 2
All other fields are text
This table is connected (1 to many) to

Table: GtDB
Key::GtDBID
This field joins the tables using the destination name
Foreign Key: GtDID
Data Type: Number (long integer)
Display Control: Combo Box
Row Source Type: Table/Query
Row Source: SELECT GtDestinations.GtDID, GtDestinations.Destination FROM
GtDestinations;
Bound Column: 1
Column Count: 2
This Table has a form

Form: TextForm
There is a Combo Box in the header to select records
Control Source: GtDID
Row Source Type: Table/Query
Row Source: SELECT [GtDID], Destination, DestinationType, Publish FROM
GtDestinations ORDER BY Destination;
Bound Column: 1

Thank you

Peter

 

[Peter Stone]

Me.Requery