open subform in new window

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have numerous tab pages each with a different record source. It was
suggested that i just include a subform to do this. However the open subform
in new window option is greyed out. Is this because I have it on a tab page?
 
I have numerous tab pages each with a different record source.
Click to expand...

No, you don't.

A Tab Control is just a way of controlling screen real estate. You can
put controls on a tab page (which controls where they appear on the
screen), but all of the controls on a Form have the same Recordsource,
whethere they are on a tab page or not.
It was
suggested that i just include a subform to do this. However the open subform
in new window option is greyed out. Is this because I have it on a tab page?
Click to expand...

No. I'm not at all sure what you're trying to do. You are aware that
the "separate page" option is only available in Design mode, right?

John W. Vinson[MVP]
 
What I am trying to accomplish is: There are numerous tables. Instead of
closing one form and opening the next to enter data, I want them to be in one
form with a sequence of tab pages so that navigation could be easier. I
tried initially to include all of the tables in a query and use the query as
a record source. However, all of the pages came up blank in form view.
 
Your method may have worked except you probably required ALL the sub
tables to be there - link criteria said show only those records where
BOTH were there. Change it to be All of master and only those of subs
that matched.
 
problem with that method for adding new data is the child relationships
are NOT there so cannot add new sub tables entries. (looky but NO
changy)
If your masterform has the parent table and say tabs each have a
sub-child form (or two or three) then that should handle the new data
problem.
 
What I am trying to accomplish is: There are numerous tables. Instead of
closing one form and opening the next to enter data, I want them to be in one
form with a sequence of tab pages so that navigation could be easier. I
tried initially to include all of the tables in a query and use the query as
a record source. However, all of the pages came up blank in form view.
Click to expand...

That's because the One Grand Monster Query is the wrong approach. The
query joining all these tables almost certainly won't retrieve any
records and won't be updateable.

Instead, use a Subform on each tab page, one subform for each table.

I have some real concerns about the design of your database though -
are these lots of unrelated tables? Or how are your tables related to
one another? Do you have a logical set of one-to-many relationships,
or are you using multiple tables to get around the (absurdly large)
255 field limit?

John W. Vinson[MVP]
 
Back
Top