Strange Subform Behavior, Access 2010
Feb 16 2017, 10:39 AM
Joined: 2-June 11
Strange problem I don't recall having before.
I have a client with an application that uses the Access 2010 Navigation form. This is working fine. One of the subforms that displays in this navigation form is frmAssets (attached). You can refer to this subform with:
On frmAssets, there are a number of other subforms, one of which is sub_frmAssetPartSchedule, which has a SourceObject of frmAssetPartSchedule, and which is linked to frmAssets on the AssetID field. For some reason, this form (frmAssetPartSchedule) will not display properly within the subform, despite the fact that it is configured properly and when I check to make sure it is configured as visible and the sourceobject is configured, I get:
But when I attempt:
I get the error message (attached)
This is not rocket science and all of the other subforms embedded in frmAssets work properly and are configured exactly the same way as this one. I am able to open frmAssetPartSchedule and it displays the 3 records I would expect with the AssetID which matches the AssetID on frmAssets.
This has got to be something simple, but I just cannot figure out what is going on.
sub_AssetPartSched_not_Displaying.jpg ( 77.92K )Number of downloads: 5
sub_AssetPartSchedule_RecordSource_ErrorMessage.jpg ( 31.69K )Number of downloads: 1
frmAssetPartSchedule.jpg ( 58.49K )Number of downloads: 3
|Search Top Lo-Fi||20th February 2017 - 04:01 AM|