A2K REPOST - all controls on subform disappear after delete

[This is still causing me grief; any ideas???? - I thought a Requery would
fix this but to no avail]


If I create 2 or more records in my subform and I then delete the main
record, then all the controls on my subform disappear.

Yet if there is only one record in the subform then it gets deleted ok and
the controls are still there ready to await further input.

Further info;

Cascading Deletes are on.
The subform Cycle property is set to Current Record.
Several fields in the table underlying the subform have default values.

Importantly I notice that if there is another main record before the one I
delete, then the subform displays ok.

Any ideas? This one is really driving me nuts!

thanks
Martin

re: A2K REPOST - all controls on subform disappear after delete

"Deano" <deanma66999@hotmail.com> wrote in message
news:wAgpb.3789$lm1.20300@wards.force9.net...[color=blue]
> If I create 2 or more records in my subform and I then delete the main
> record, then all the controls on my subform disappear.
>
> Yet if there is only one record in the subform then it gets deleted ok[/color]
and[color=blue]
> the controls are still there ready to await further input. [snip][/color]

Are you sure they are not just scrolled up off screen?


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

re: A2K REPOST - all controls on subform disappear after delete

"Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
news:bo5mav$17o87f$1@ID-98015.news.uni-berlin.de...[color=blue]
> "Deano" <deanma66999@hotmail.com> wrote in message
> news:wAgpb.3789$lm1.20300@wards.force9.net...[color=green]
> > If I create 2 or more records in my subform and I then delete the main
> > record, then all the controls on my subform disappear.
> >
> > Yet if there is only one record in the subform then it gets deleted ok[/color]
> and[color=green]
> > the controls are still there ready to await further input. [snip][/color]
>
> Are you sure they are not just scrolled up off screen?
>[/color]

Thanks for the reply Rick. No I should have mentioned it's not a continuous
form. If I exit the form and re-enter then all is well.
The only thing I can think of doing is to suppress screen updating, close
the form, reopen the form and then Echo on again.

re: A2K REPOST - all controls on subform disappear after delete

"Deano" <deanma66999@hotmail.com> wrote in message
news:E6tpb.3932$lm1.20870@wards.force9.net...[color=blue]
>
> "Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
> news:bo5mav$17o87f$1@ID-98015.news.uni-berlin.de...[color=green]
> > "Deano" <deanma66999@hotmail.com> wrote in message
> > news:wAgpb.3789$lm1.20300@wards.force9.net...[color=darkred]
> > > If I create 2 or more records in my subform and I then delete the[/color][/color][/color]
main[color=blue][color=green][color=darkred]
> > > record, then all the controls on my subform disappear.
> > >
> > > Yet if there is only one record in the subform then it gets deleted[/color][/color][/color]
ok[color=blue][color=green]
> > and[color=darkred]
> > > the controls are still there ready to await further input. [snip][/color]
> >
> > Are you sure they are not just scrolled up off screen?
> >[/color]
>
> Thanks for the reply Rick. No I should have mentioned it's not a[/color]
continuous[color=blue]
> form. If I exit the form and re-enter then all is well.
> The only thing I can think of doing is to suppress screen updating, close
> the form, reopen the form and then Echo on again.[/color]

Does the subform allow additions? When you delete the main record, are you
left positioned at a different main record or the blank new record
position?

The reason I ask is because a form with no current record to display AND
which doesn't allow new records to be inserted will appear totally blank
(no controls, labels, etc.).


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

re: A2K REPOST - all controls on subform disappear after delete

"Rick Brandt" <rickbrandt2@hotmail.com> wrote in message
news:bo5ort$182q1b$1@ID-98015.news.uni-berlin.de...
[color=blue]
>
> Does the subform allow additions? When you delete the main record, are[/color]
you[color=blue]
> left positioned at a different main record or the blank new record
> position?
>
> The reason I ask is because a form with no current record to display AND
> which doesn't allow new records to be inserted will appear totally blank
> (no controls, labels, etc.).[/color]

Cheers Rick, that was it.

I paid a developer to look at this and he didn't catch it properly! (:

Thanks for you help!