|
Home > Archive > MS Access database support > June 2005 > Newbie question-subforms
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Newbie question-subforms
|
|
|
| Hi,
I'm new to various parts of Access that I need to use in my AS
computing coursework, one of which is subforms. I am attempting to
create a form with a subform using a wizard, as instructed by a
step-by-step guide I am using. However, when I get to the point where
there should be a screen asking which fields you want in your main form
and which you want in your subform, it does not appear!
I am thoroughly confused by this, and would appreciate any ideas!
Thanks,
Madia
| |
| Beacher 2005-06-30, 1:29 pm |
| Are you talking about the child/master links, or actual fields on the
subform? I could be wrong but I think the subform wizard only asks you
what fields you want on the subform.. which you can add to later by
selecting View/Field List
| |
| Justin Hoffman 2005-06-30, 1:29 pm |
| "Madia" <elven_lomadia@yahoo.co.uk> wrote in message
news:1120155101.984196.77450@g14g2000cwa.googlegroups.com...
> Hi,
>
> I'm new to various parts of Access that I need to use in my AS
> computing coursework, one of which is subforms. I am attempting to
> create a form with a subform using a wizard, as instructed by a
> step-by-step guide I am using. However, when I get to the point where
> there should be a screen asking which fields you want in your main form
> and which you want in your subform, it does not appear!
>
> I am thoroughly confused by this, and would appreciate any ideas!
>
> Thanks,
> Madia
>
In order for the wizard to be able to do it's work, both forms should be
'bound'. That is, when you open each form in design view, you should have a
table/query as the RecordSource property. If one or more is unbound (no
record source) the wizard would not be able to set the link child/master
fields - since at least one of the forms doesn't even have any fields.
Is that the issue here?
| |
| Larry Linson 2005-06-30, 8:25 pm |
| "Madia" wrote
> I'm new to various parts of Access
> that I need to use in my AS computing
> coursework, one of which is subforms. I
> am attempting to create a form with a
> subform using a wizard, as instructed by a
> step-by-step guide I am using. However,
> when I get to the point where there should
> be a screen asking which fields you want in
> your main form and which you want in your
> subform, it does not appear!
What version of Access are you using? Which Service Packs, if any, have been
applied? What Wizard are you using... if the name is not obvious, how did
you reach it from the database window?
In Access 2002, I use the "Create form by using Wizard" entry on the Forms
tab, specify the "Orders" table from a copy of the Northwind sample
database, and it gives me a list of Fields from which I can choose. Then I
use the "Subform/Subreport" Wizard from the Toolbox, specifiy the
"OrderDetails" table and I again am given a list of Fields. That, however,
clearly is using two Wizards.
Larry Linson
Microsoft Access MVP
|
|
|
|
|