[AccessD] Sub Subform not showing

[David Emerson]

Hi Charlotte,

The problem is not when there are no records but when there are records.
The forms work as expected when there are no records in the parent object.
To quote from my original post:

"If I move to a record in frmClient which does not have records in sfrSurvey
then sfrSurvey shows no records and the details section is blank (which is
expected).  Because sfrSurvey is blank then sfrResults is not shown as well
(as expected).

Here is the problem: If I now move to a record in frmClient which does have
records in sfrSurvey the records are showing in sfrSurvey but where the
sfrResults subform should be is a white box.  It looks like the sfrResults
control doesn't have the Source Object property but using VBA I can display
the SourceObject property just before the recordset is updated and it
appears fine."

As noted in my original email it seems to be related to the AllowAdditions
property.  If I change this to true then the subforms show (but in this case
I don't want the user to be able to add records)

Regards

David
-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Wednesday, 8 July 2015 5:42 a.m.
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Sub Subform not showing

First off, if a parent object has no records, then its subform will have no
records.  It's always been that way, and if the Allow additions is set off,
you won't see either the parent or subform.  The simplest way I can think of
to handle this is to set Allow Additions on by default in the form/subform
and then use code on the Enter event to disable additions.

Charlotte Foust
(916) 206-4336

On Sat, Jul 4, 2015 at 2:51 PM, David Emerson <newsgrps at dalyn.co.nz> wrote:

> Hi Listers,
>
> I have an Access 2010 FE and SQL 2008 BE.  I have a form (frmClients) 
> that has a tab control with a number of tabs and subforms in each tab.  
> Most of the subforms have subforms of their own.  Record sources for 
> all the forms and subforms are set by assigning a ADODB.Recordset when 
> a record is selected from the main form (these filter the records 
> according to the main record selected).
>
> All is working well except for one subform (sfrSurvey) which has its 
> own subform (sfrResults).  All of the other subforms are set so that 
> records can be added but sfrSurvey has its Allow Additions property 
> set to no (records are added through a different process).
>
> When I open frmClient the first record happens to have a record in 
> sfrSurvey and this in turn shows records for sfrResults.  If I move to 
> another record in frmClient which has records in sfrSurvey then 
> records also show in sfrResults.
>
> If I move to a record in frmClient which does not have records in 
> sfrSurvey then sfrSurvey shows no records and the details section is 
> blank (which is expected).  Because sfrSurvey is blank then sfrResults 
> is not shown as well (as expected).
>
> Here is the problem: If I now move to a record in frmClient which does 
> have records in sfrSurvey the records are showing in sfrSurvey but 
> where the sfrResults subform should be is a white box.  It looks like 
> the sfrResults control doesn't have the Source Object property but 
> using VBA I can display the SourceObject property just before the 
> recordset is updated and it appears fine.
>
> The line of code where the problem appears is:
>
>         Set 
> Me!sfrQualitySurvey.Form!sfrQualitySurveyResult.Form.Recordset
> =
> rstTemp
>
> The error number is 2467 "The expression you entered refers to an 
> object that is closed or doesn't exist.".
>
> There is nothing in my code that purposely changes the SourceObject 
> property
> - the only changes are to the recordsource of the subforms.  None of 
> the other subforms have this problem.  I have tested by changing one 
> of the other subforms to not allow additions and it showed the same
problem.
> Changing it back to allowing additions solved the problem.  However, 
> for this particular subform I don't want to allow additions and would 
> prefer not to have the screen indicate that additions can be made only 
> to have the user told they can't if they try (by using code).
>
> Has anyone come across anything like this before?
>
> Regards
>
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com