Refresh nested subforms
- From: "Peter Stone" <PeterStone@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 15 Jan 2006 19:16:01 -0800
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
.
- Prev by Date: Re: Ms Flexgrid Control
- Next by Date: Infinite Loop in ErrorHandler That Requires Hard Shutdown
- Previous by thread: Rollback in error handler
- Next by thread: Infinite Loop in ErrorHandler That Requires Hard Shutdown
- Index(es):
Relevant Pages
|
