Is it possible to add a subform after the original form has been u

M

mabyn

I have a form I created from "Table A". I just created "Table B" and would
like to make it a subform of of the first. I have created a new form but
don't understand how or where or if I can put a link??? on Form A that will
send me to the subform.
 
D

Dirk Goldgar

mabyn said:
I have a form I created from "Table A". I just created "Table B" and would
like to make it a subform of of the first. I have created a new form but
don't understand how or where or if I can put a link??? on Form A that
will
send me to the subform.


If you are really talking about creating a subform (on another, main, form),
then you can just open the main form in design view, then drag the
subform-to-be from the database window/navigation pane and drop it onto the
"canvas" of the main form. You may or may not have to then adjust the Link
Master Fields and Link Child Fields properties of the subform control that
will be created in this manner -- it depends on whether Access can figure
out how the forms are related.
 
M

mabyn

Let me say that I do not know if I am misusing terminology. I really don't
know if these are 'real' main forms. In my database I have
Attendees (as a main form I think since it is the 1st form I enter on)
then on that form there are "links" to Registration Form, Payments Form,
Preview Invoice,
Registration (I was thinking this was still a main form but obviously it is
not < ths was my original table A in my first example>)

I guess from either the Attendees form or the Registration form I need to
have a linked form called Lineup.
 
D

Dirk Goldgar

mabyn said:
Let me say that I do not know if I am misusing terminology. I really don't
know if these are 'real' main forms. In my database I have
Attendees (as a main form I think since it is the 1st form I enter on)
then on that form there are "links" to Registration Form, Payments Form,
Preview Invoice,
Registration (I was thinking this was still a main form but obviously it
is
not < ths was my original table A in my first example>)

I guess from either the Attendees form or the Registration form I need to
have a linked form called Lineup.


From the sound of it, this is not what we would call a subform. It's just
another form that is opened from one of the existing forms. It may be
related to the record that is current on the "calling" form, or it may be
entirely independent of that record, depending on how you set it up.

You can add a command button to one form to open another form. Normally, if
you don't have control wizards switched off, Access will help you do this --
just go into design view, choose the command button tool and then click the
location on the form where you want to add the button. The wizard will then
offer you some choices for what you want the button to do, and guide you
through the steps to set up the button to do it. Have you tried this
procedure yet?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top