Re: Sub-SubForm Reference Problem

Per David W. Fenton:
Setting the form to allow additions should give you at least one
record. You can disable the control so the user can't type until
they've initiated a legal add.

You mean disabling the subform control that has the offending form as it's
..SourceObject, right?

I never would have thought of that - and it sounds like the simplest
solution.... even to the point of implementing across all of my forms/subforms
because occurrence of the problem would seem tb data-dependent and therefore
lurking in other forms/subforms. i.e. avoiding it depends on a given subform
having records behind it..

Thanks.
--
PeteCresswell
.

Relevant Pages

  • Re: tab control & user level security
    ... Chris, on reflection, I think that my suggested approach (of disabling the ... subform control, or the tab page) will not work in the way I suggested. ... F, then, the code in M will never get a chance to disable the relevant tab ... > I certainly retain your suggestion about testing whether the user has ...
    (microsoft.public.access.forms)
  • Re: tab control & user level security
    ... Chris, on reflection, I think that my suggested approach (of disabling the ... subform control, or the tab page) will not work in the way I suggested. ... F, then, the code in M will never get a chance to disable the relevant tab ... > I certainly retain your suggestion about testing whether the user has ...
    (microsoft.public.access.security)
  • Re: tab control & user level security
    ... > Chris, on reflection, I think that my suggested approach (of disabling the ... > subform control, or the tab page) will not work in the way I suggested. ... > HTH, ...
    (microsoft.public.access.security)
  • Re: tab control & user level security
    ... > Chris, on reflection, I think that my suggested approach (of disabling the ... > subform control, or the tab page) will not work in the way I suggested. ... > HTH, ...
    (microsoft.public.access.forms)
  • Re: subform help!
    ... Open the main form in design view. ... Right-click the edge of the subform control, ... Make sure the Title bar of the Properties box says, ... I need to check that my forms/subforms are linked the way ...
    (microsoft.public.access.forms)