Odd Subform behaviour

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JohnB - 12 Mar 2008 12:23 GMT

Hi.

I have a subform that I've just spotted doing odd things. When a record
doesn't exist for the subform to show, none of the text boxes and labels etc
appear. The subform shows OK, including the record selector at the bottom but
the subform is just a blank. When a record does exist, the subform shows as
normal. There is no Even code on either the subform or main form.

I created another subform and placed it on the main form and it behaves OK.

Any ideas?

Reply to this Message

Allen Browne - 12 Mar 2008 13:49 GMT

See:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

The thing will be to figure out why this subform meets both those
conditions.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I have a subform that I've just spotted doing odd things. When a record
> doesn't exist for the subform to show, none of the text boxes and labels
[quoted text clipped - 7 lines]
> I created another subform and placed it on the main form and it behaves
> OK.

Reply to this Message

JohnB - 12 Mar 2008 18:34 GMT

Thanks Allen.

I'll check out those conditions tomorrow when I'm back in work. I've
certainly set the subform to be 'view only', so that users can't modify any
of the records in that particular form/subform, so I think you are definitely
on to something there.
I'll let you know the outcome, holefully tomorrow.

Thanks again. JohnB

> See:
> Why does my form go completely blank?
[quoted text clipped - 15 lines]
> > I created another subform and placed it on the main form and it behaves
> > OK.

Reply to this Message

JohnB - 15 Mar 2008 13:40 GMT

Hi again.

Sorry for the delay in replying. I've sorted this now. It turned out that
one of the tables used in tyhe query that supplies the form did not have a
primary key allocated. This is a bit embarrasing - I thought I'd allocated a
primary key to all tables at the desigh stage. Anyway, that seems to have
solved it.

The mdb does seem to have behaved OK for some years without it, so hopefully
it will continue to do so now that I've corrected the omission.

Thanks for the help Allen

> Thanks Allen.
>
[quoted text clipped - 25 lines]
> > > I created another subform and placed it on the main form and it behaves
> > > OK.

Reply to this Message

Allen Browne - 15 Mar 2008 14:49 GMT

Great: all solved.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> The mdb does seem to have behaved OK for some years without it, so
> hopefully
> it will continue to do so now that I've corrected the omission.
>
> Thanks for the help Allen

Reply to this Message