Hiding subform

[Caroline Bradford]

Hi there, I wonder if there is a kind and knowledgeable person out
there who can help me with a sticky problem.

I have a form with a subform which shows detailed data. For
complicated reasons, which I won't go into, the detail which I require
cannot be determined programmaticall y, so I planned to have two
subforms, identical in design but with slightly different data,
dependent on a criterion in the main form. Both will sit on the form,
but exactly on top of each other, with the relevant one being visible
and the unwanted one not. However, this is not working properly. In
case (a) it is fine because the topmost (visible) form completely
covers the other one. But in case (b), where I want the bottommost
(is that a real word?) subform to show, the top one appears as a grey
box. No data, but it obscures the subform I wish to see. What am I
doing wrong?

Hope this makes sense and someone can point out the error of my ways.

Regards

Caroline Bradford

[Peter Doering]

Hide the subform that you don't want to see:

If YourCondition = True Then
Me!subFrm1.Visi ble = False
Me!subFrm2.Visi ble = True
Else
Me!subFrm2.Visi ble = False
Me!subFrm1.Visi ble = True
End If

HTH - Peter
On 12 Nov 2003 14:57:13 -0800, Caroline Bradford wrote:

Hi there, I wonder if there is a kind and knowledgeable person out
there who can help me with a sticky problem.

I have a form with a subform which shows detailed data. For
complicated reasons, which I won't go into, the detail which I require
cannot be determined programmaticall y, so I planned to have two
subforms, identical in design but with slightly different data,
dependent on a criterion in the main form. Both will sit on the form,
but exactly on top of each other, with the relevant one being visible
and the unwanted one not. However, this is not working properly. In
case (a) it is fine because the topmost (visible) form completely
covers the other one. But in case (b), where I want the bottommost
(is that a real word?) subform to show, the top one appears as a grey
box. No data, but it obscures the subform I wish to see. What am I
doing wrong?

--
No mails please.

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You should be setting the active subform control's Visible property to
True and the inactive subform control's Visible property to False.
- --
MGFoster:::mgf
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBP7LG2YechKq OuFEgEQKXVgCeNQ jDjXgK664CHhVdl nIuLeTnds8AnRrF
IsUc8Vg9S+EszPQ kjcXAdHFk
=6+8U
-----END PGP SIGNATURE-----

Caroline Bradford wrote:

Hi there, I wonder if there is a kind and knowledgeable person out
there who can help me with a sticky problem.

I have a form with a subform which shows detailed data. For
complicated reasons, which I won't go into, the detail which I require
cannot be determined programmaticall y, so I planned to have two
subforms, identical in design but with slightly different data,
dependent on a criterion in the main form. Both will sit on the form,
but exactly on top of each other, with the relevant one being visible
and the unwanted one not. However, this is not working properly. In
case (a) it is fine because the topmost (visible) form completely
covers the other one. But in case (b), where I want the bottommost
(is that a real word?) subform to show, the top one appears as a grey
box. No data, but it obscures the subform I wish to see. What am I
doing wrong?

Hope this makes sense and someone can point out the error of my ways.

Regards

Caroline Bradford

[Fletcher Arnold]

"Caroline Bradford" <ca************ ***@btinternet. com> wrote in message
news:eb******** *************** ***@posting.goo gle.com...

Hi there, I wonder if there is a kind and knowledgeable person out
there who can help me with a sticky problem.

I have a form with a subform which shows detailed data. For
complicated reasons, which I won't go into, the detail which I require
cannot be determined programmaticall y, so I planned to have two
subforms, identical in design but with slightly different data,
dependent on a criterion in the main form. Both will sit on the form,
but exactly on top of each other, with the relevant one being visible
and the unwanted one not. However, this is not working properly. In
case (a) it is fine because the topmost (visible) form completely
covers the other one. But in case (b), where I want the bottommost
(is that a real word?) subform to show, the top one appears as a grey
box. No data, but it obscures the subform I wish to see. What am I
doing wrong?

Hope this makes sense and someone can point out the error of my ways.

Regards

Caroline Bradford

It is quite common for people to try a number of tricks when the standard
form / subform does not work and, like you say, the details of any one
database may be too complicated to bore the newsgroup with the details.
However, without further details it is very hard to imagine 'what you are
doing wrong'. Unless someone can guess, I think you might have to post some
idea of table structure, some code and what you are trying to achieve.
Who knows, you may be able to get away with one subform and simply
programmaticall y changing its datasource.

Fletcher

[Caroline Bradford]

Many thanks to all those who took the trouble to offer help with this.
However, I think I need to clarify the problem more precisely. I
have successfully coded the form so that only one of the subforms is
visible at any one time (dependent on the current record). If I place
the two subforms side by side, everything works fine - either the left
or right one is seen. However, this looks ugly, is a waste of space,
and confuses users as they cycle through the records. What I wanted
to do was place the subforms exactly on top of each other, so that
whichever one was visible it would appear to the user to be the same
form. This is where the problem lies. When the topmost form is the
"invisible" one, it isn't actually invisible - it appears as a
completely flat grey rectangle, obscuring the visible subform
underneath. In other words, the subform is not becoming invisible, it
is simply becoming part of the background. I can only conclude that
this is actually what Access does - the control is not invisible, it
is simply becoming a chameleon and hiding itself in the background of
the form.

Oh well, back to the drawing board!
Peter Doering <no****@doering .org> wrote in message news:<bo******* ******@ID-204768.news.uni-berlin.de>...

Hide the subform that you don't want to see:

If YourCondition = True Then
Me!subFrm1.Visi ble = False
Me!subFrm2.Visi ble = True
Else
Me!subFrm2.Visi ble = False
Me!subFrm1.Visi ble = True
End If

HTH - Peter
On 12 Nov 2003 14:57:13 -0800, Caroline Bradford wrote:

Hi there, I wonder if there is a kind and knowledgeable person out
there who can help me with a sticky problem.

I have a form with a subform which shows detailed data. For
complicated reasons, which I won't go into, the detail which I require
cannot be determined programmaticall y, so I planned to have two
subforms, identical in design but with slightly different data,
dependent on a criterion in the main form. Both will sit on the form,
but exactly on top of each other, with the relevant one being visible
and the unwanted one not. However, this is not working properly. In
case (a) it is fine because the topmost (visible) form completely
covers the other one. But in case (b), where I want the bottommost
(is that a real word?) subform to show, the top one appears as a grey
box. No data, but it obscures the subform I wish to see. What am I
doing wrong?

[Lyle Fairfield]

ca************* **@btinternet.c om (Caroline Bradford) wrote in
news:eb******** *************** ***@posting.goo gle.com:

Oh well, back to the drawing board!

In your original post you say:

************
I planned to have two subforms, identical in design but with slightly
different data, dependent on a criterion in the main form
************

If this is the case then it's quite likely that you do not need two subforms.
One subform whose recordsource is changed on changing the citerion in the
main form should be sufficient.

--
Lyle
(for e-mail refer to http://ffdba.com/contacts.htm)

[Peter Doering]

On 13 Nov 2003 13:16:39 GMT, Lyle Fairfield wrote:

ca************* **@btinternet.c om (Caroline Bradford) wrote in
news:eb******** *************** ***@posting.goo gle.com:

Oh well, back to the drawing board!

In your original post you say:

************
I planned to have two subforms, identical in design but with slightly
different data, dependent on a criterion in the main form
************

If this is the case then it's quite likely that you do not need two subforms.
One subform whose recordsource is changed on changing the citerion in the
main form should be sufficient.

And, if not RecordSource, at least having /one/ subform control and
replacing the SourceObject should help.

Peter

--
No mails please.

[Andante.in.Blue]

I've done something similar, though for purely aesthetic reasons.
Just use a tab control and stick your subforms on 2 different pages,
using code to switch pages. Then, set the tab control to have Style =
"None" and Back Style = "Transparen t".

This also allows you to place a whole bunch of other things onto the
pages (like labels and such) without adding any more code. To add an
object to a particular page (as suppose to over top of the tab
control), you will have to cut the object, and paste it with the
appropriate page selected. To edit the individual pages, you'll have
to set Style = "Tabs" or "Buttons", then set it back to "None" when
you are done.

Alan

Peter Doering <no****@doering .org> wrote in message news:<bp******* ******@ID-204768.news.uni-berlin.de>...

On 13 Nov 2003 13:16:39 GMT, Lyle Fairfield wrote:

ca************* **@btinternet.c om (Caroline Bradford) wrote in
news:eb******** *************** ***@posting.goo gle.com:

Oh well, back to the drawing board!

In your original post you say:

************
I planned to have two subforms, identical in design but with slightly
different data, dependent on a criterion in the main form
************

If this is the case then it's quite likely that you do not need two subforms.
One subform whose recordsource is changed on changing the citerion in the
main form should be sufficient.

And, if not RecordSource, at least having /one/ subform control and
replacing the SourceObject should help.

Peter