Creating subforms

[Guest]

Hi,

I am working on main form faculty that has 3 subforms. I used the available
wizard to create the mainf form (faculty details) linked by command button to
another subform (couses). However, I need to create a third subform
(committee) that should be linked by command button to the main form. It
seems that the wizard cretes one subform at atime is it correct? and how to
created the committee subform at the same time.

 

[tina]

i don't understand the question. what do you mean by "main form linked by
command button to another subform"?

are you using the term "subform" correctly? a subform is a form object that
is displayed *within* another form, by the use of a subform control in the
main form. you can create a "main" form, open it in design view, and then
add a subform one of two ways: 1) add a subform control from the Toolbox
toolbar, and then set the subform control's SourceObject property to the
name of the form object that you want to display as a subform, or 2) resize
the "main" form window so that you can see the database window, and drag a
form object from the database window into the "main" form design view -
Access automatically creates the subform control and sets its' SourceObject
property to that form object's name.

if you are using a command button on one form to open another form in a
separate window, then the terms "main form" and "subform" do not apply. i
also don't understand what you mean by "It seems that the wizard cretes one
subform at atime" - what wizard are you talking about? when and where do you
open this wizard?

hth

 

[Guest]

Hi Tina,

What I mean is I have faculty form and I want to create acommand button that
takes me to another form (couses_. I made that by using create form wizard.
However, I need to create another command in the same faculty form that takes
me to committee form (seperate form) and sorry for the missunderstanding from
my side.
--
My Regards,
Buthy

i don't understand the question. what do you mean by "main form linked by
command button to another subform"?

are you using the term "subform" correctly? a subform is a form object that
is displayed *within* another form, by the use of a subform control in the
main form. you can create a "main" form, open it in design view, and then
add a subform one of two ways: 1) add a subform control from the Toolbox
toolbar, and then set the subform control's SourceObject property to the
name of the form object that you want to display as a subform, or 2) resize
the "main" form window so that you can see the database window, and drag a
form object from the database window into the "main" form design view -
Access automatically creates the subform control and sets its' SourceObject
property to that form object's name.

if you are using a command button on one form to open another form in a
separate window, then the terms "main form" and "subform" do not apply. i
also don't understand what you mean by "It seems that the wizard cretes one
subform at atime" - what wizard are you talking about? when and where do you
open this wizard?

hth

 

[tina]

okay, so you have three separate forms: frmFaculty, frmCourses, and
frmCommittee. in frmFaculty, you want to two command buttons: one that
opens frmCourses, and one that opens frmCommittee. is this correct so far?
if so, then just use the Controls wizard to create a command button, and set
it up to open frmCourses (the wizard will walk you through this). then use
the Controls wizard again to create another command button, and set it up to
open frmCommittee.

if i'm not getting your point, please explain further.

hth

Hi Tina,

What I mean is I have faculty form and I want to create acommand button that
takes me to another form (couses_. I made that by using create form wizard.
However, I need to create another command in the same faculty form that takes
me to committee form (seperate form) and sorry for the missunderstanding from
my side.