Populate a subform after detail.visible produces an error

[lauren quantrell]

I have an Access 2000 form that I open showing only the header. The
form's detail section visible property is set to false.
The detail section contains a subform. Using a command button, I use
the code:
Me.Detail.Visible = true
Me.SubFormName.Form.RecordSource = "sprocXYZ"

It returns the following error:
"2455 - You have entered an expression that has an invalid reference to
the property Form/Report."

If I set the form's detail section visible property to true in design
mode, the code works fine.

For some reason, Access doesn't recognize the subform if the form opens
with the detail section set to false.
Is there a workaround for this?
Thanks,
lq

[Arno R]

> For some reason, Access doesn't recognize the subform if the form opens

with the detail section set to false.
Is there a workaround for this?

Hi Lauren,
I just tested this and found out that 'some' of the detail must be 'visible' in order for your code to work.
So if I just open the form (detail.invisible) with only the header shown then it won't work.
Same error as you indicate
When I go to design view and back to normal view it works (empty detail section is 'visible')
When I resize the form just a little bit before I click the button, the code works...

Workaround could be: Me.AutoResize = false... but you will 'see' the empty form.
I am not sure if this is what you want, because you could do the same by setting al controls to visible / invisible ?

Maybe you could just make the subformcontrol visible /invisible ?

--
Hope this helps
Arno R

[lauren quantrell]

Arno,
Thanks for the reply. After I pulled out some hair trying to figure
this out I too discovered it had to do with needing at least a sliver
of the detail section visible. I can't (don't want to actually) hide
the controls because there are so many of them. I prefer just to hide
the detail section.
It baffles my why Access returns an error that a control doesn't exisit
if the form is sized so that the detail section isn't showing.
My workaround was:
the form height = me.formheader.height + 200.
That leaves a sliver of the (invisible) detail section showing and
allows me to address the controls without error before I populate and
resize the form.
lq

[Arno R]

"lauren quantrell" <la*************@hotmail.com> schreef in bericht news:11*********************@f14g2000cwb.googlegro ups.com...

It baffles my why Access returns an error that a control doesn't exisit
if the form is sized so that the detail section isn't showing.

It's just one of 'those things'.
We have to live with them don't we?
Access sometimes tries to be *too* helpful ...

Arno R