[AccessD] Sub Subform not showing

[Charlotte Foust]

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
>