Parent/Child..Subform Tab Page

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

Guest

I have been reading posts to try and solve a problem. I am somewhat new to
Access so forgive me if needed.

I am trying to "link" 2 forms. The first form creates a job number via
autonumber. The user enters Owner info, etc. Due to screen space, I need to
open another form to allow the user to enter additonal info. I would like to
have the 2nd form show the job number (which was just created by autonumber)
and name at the top. Is this possible?

Is it possible to create a subform that could be linked to a command button?
Where can I get more info on Subform Tab Page. I have seen it referenced in
posts and I tried finding it in Access help and every book I have...nada

Much appreciation in advance for any help!!!!!
 
subforms and tab controls (which have Pages) are two different things. you
can put a subform by itself on a form; you can put a tab control with one or
more pages on a form; and you can put a tab control on a form and put a
subform on a Page of the tab control.

a tab control with multiple pages pretty much gives you extra space in order
to fit more on a form and keep it easily accessible without having to do a
lot of scrolling. it helps you group and control the display of large
amounts of data.

a subform (which is actually a separate form that "sits inside" a subform
control on the main form) usually displays records in a "child" table that
is linked to a "parent" table. the parent table's records are usually
displayed on the main form.

from your post, it sounds like you have one table with some fields displayed
in a main form, and you want to display additional fields *from the same
table* in a subform. this can be problematic when you're attempting to add
new records. for this scenario, suggest you use a tab control on your main
form, and forget the subform idea.

hth
 
Thanks a million! Thats clears things up a bit.
Where do I acess the tab control for multiple pages?
 
I just found it - thanks so much for your help.

smboyd said:
Thanks a million! Thats clears things up a bit.
Where do I acess the tab control for multiple pages?
Click to expand...
 
Back
Top