Odd Subform behaviour

[JohnB]

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?

 

[Allen Browne]

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.

 

[JohnB]

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

 

[JohnB]

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

 

[Allen Browne]

Great: all solved.