subform/subreport question

[alex]

Hello,

using Access '03...

I have two questions about a subform/subreport:

I've searched the archives of this group and it appears that you can
hide the navigation buttons on a subform. When I look at the
properties of my subform (in design view), however; turning on/off the
navigation buttons is not an option.

I would also like to programatically (with a command or option button)
show/hide particular columns on the subform...can I do that?

What I basically have is a form with a subform/subreport below in
datasheet view. When I look at the subform/subreport in design view,
all that I see is a table reference.

Thanks,
alex

 

[Brendan Reynolds]

Hello,

using Access '03...

I have two questions about a subform/subreport:

I've searched the archives of this group and it appears that you can
hide the navigation buttons on a subform. When I look at the
properties of my subform (in design view), however; turning on/off the
navigation buttons is not an option.

I would also like to programatically (with a command or option button)
show/hide particular columns on the subform...can I do that?

What I basically have is a form with a subform/subreport below in
datasheet view. When I look at the subform/subreport in design view,
all that I see is a table reference.

Thanks,
alex

By the sound of it, what you're looking at is the subform *control*. The
properties you're looking for are not properties of the subform control, but
of the form that you display within that control. You can also use a table
or query directly as the SourceObject of a subform control, but you won't be
able to do what you want that way. You need to create a form bound to your
table or query and then enter the name of that form in the SourceObject
property of your subform control.

 

[alex]

By the sound of it, what you're looking at is the subform *control*. The
properties you're looking for are not properties of the subform control, but
of the form that you display within that control. You can also use a table
or query directly as the SourceObject of a subform control, but you won'tbe
able to do what you want that way. You need to create a form bound to your
table or query and then enter the name of that form in the SourceObject
property of your subform control.

Thanks Brendan for your response...

Let me see if I understand! Currently (on my main form) I have a
subform control, which basically means my subform is directly tied to
a table.

In order to manipulate the subform, it has to actually be a form
itself and then placed in my main form.

Did I get it? And if I do what you suggested, can I hide columns in
datasheet view dynamically?

alex

 

[Brendan Reynolds]

<snip>
Thanks Brendan for your response...

Let me see if I understand! Currently (on my main form) I have a
subform control, which basically means my subform is directly tied to
a table.

In order to manipulate the subform, it has to actually be a form
itself and then placed in my main form.

Did I get it? And if I do what you suggested, can I hide columns in
datasheet view dynamically?

The SourceObject property of your subform control can be the name of a form,
a table, or a query. What leads me to think that it is currently a table is
that in your original post you said that when you looked at the properties
you saw a table name. If the SourceObject property of your subform control
is the name of a form, then you can hide columns at run time by setting the
ColumnHidden property.