UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Strange Subform Behavior, Access 2010    
 
   
fyed
post Feb 16 2017, 10:39 AM
Post#1



Posts: 33
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:

?form_frmNavigation.NavigationSubform.SourceObject
=> frmAssets

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:

?form_frmNavigation.NavigationSubform.form.sub_AssetPartSchedule.sourceobject
=> frmAssetPartSchedule
?form_frmNavigation.NavigationSubform.form.sub_AssetPartSchedule.visible
=>True

But when I attempt:

?form_frmNavigation.NavigationSubform.form.sub_AssetPartSchedule.form.recordsourc
e

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.
Attached File(s)
Attached File  sub_AssetPartSched_not_Displaying.jpg ( 77.92K )Number of downloads: 8
Attached File  sub_AssetPartSchedule_RecordSource_ErrorMessage.jpg ( 31.69K )Number of downloads: 3
Attached File  frmAssetPartSchedule.jpg ( 58.49K )Number of downloads: 5
 
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    22nd October 2017 - 09:20 PM