Access 2007 conversion subforms don't display linked records

[TybeeDi]

Any suggestions? My db has many tabbed/page "master" forms with data
entry/display subforms, most of which will NOT display the linked
(master/child) records, but some do. The Access 2003 version works great.
If I create a subform NEW on the master form the link works fine. But, there
are too many forms to redo. Other steps I have done: 1. Removed and rebuilt
the link fields master and child. 2. Removed all controversial events and
VB code. 3. Compared each field in the subform(s) that work correctly with
one that doesn't. (all were the same or were changed to test) 4. Moved the
subform to a tab/page of its own on the master form. 5. Applied the fix
AllowDesignChanges = "False" as suggested in one forum for when records won't
delete on subform (in desperation).

I am able to ADD and delete records from the subforms and data is saved to
the table. But, data will not display when the form is open again.

 

[Allen Browne]

Other things you might try:

1. Open the subform in design view, and set the new FilterOnLoad property to
No. (Also OrderByOnLoad.) This property did not exist in previous versions:
it may be filtering the subform such that it doesn't display any matching
records.

2. If the subform's RecordSource is a query that contains criteria that
refers to the main form, such as:
[Forms].[Form1].[Text0]
try removing the criteria from the query. There's a timing issue here, where
the subform has to load first, but its source depends on a value from the
main form, and A2007 handles this differently than previous versions.

3. Make sure it's not opening in DataAdd mode.

4. Make sure your database is in a trusted location.

 

[TybeeDi]

Filter on = False AND Data entry = false did the trick. Thanks to all!
Can't quite grasp the logic of data entry = false when you want to ENTER
data. Why somebody's twisted logic thinks data entry means NEW escapes me.

Other things you might try:

1. Open the subform in design view, and set the new FilterOnLoad property to
No. (Also OrderByOnLoad.) This property did not exist in previous versions:
it may be filtering the subform such that it doesn't display any matching
records.

2. If the subform's RecordSource is a query that contains criteria that
refers to the main form, such as:
[Forms].[Form1].[Text0]
try removing the criteria from the query. There's a timing issue here, where
the subform has to load first, but its source depends on a value from the
main form, and A2007 handles this differently than previous versions.

3. Make sure it's not opening in DataAdd mode.

4. Make sure your database is in a trusted location.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Any suggestions? My db has many tabbed/page "master" forms with data
entry/display subforms, most of which will NOT display the linked
(master/child) records, but some do. The Access 2003 version works great.
If I create a subform NEW on the master form the link works fine. But,
there
are too many forms to redo. Other steps I have done: 1. Removed and
rebuilt
the link fields master and child. 2. Removed all controversial events
and
VB code. 3. Compared each field in the subform(s) that work correctly
with
one that doesn't. (all were the same or were changed to test) 4. Moved
the
subform to a tab/page of its own on the master form. 5. Applied the fix
AllowDesignChanges = "False" as suggested in one forum for when records
won't
delete on subform (in desperation).

I am able to ADD and delete records from the subforms and data is saved to
the table. But, data will not display when the form is open again.