Form Dialogue Box

  • Thread starter Thread starter Greg Jesky
  • Start date Start date
G

Greg Jesky

When I use the form wizard I have options of Columnar, Tabular and
Datasheet. I am interested in creating a different format. The format looks
like a series of folders with Tab Identifiers.
I would like this format to direct user to different forms. Or to sometimes
use as a way to use this "tab type form" to update many fields within the
same record- table.
Or use this "tab type form" to replace the form/subform capabilities.
I am interested in your thoughts if this is doable and how?
I have seen in Help a way to add what I am looking for to an existing form.

Thank You,
Greg
 
You can do this by adding a Tab Control onto a form. Look in the toolbox for
the icon that looks like a stack of folders. Drag this onto your form and
you should be in business.
 
Sandra,
Thank You. Can I start with a blank form in Design mode ?
How do I the select the table I would like to use to build the fields to go
on tab 1 and tab 2?
Thank You,
Greg Jesky


Sandra Daigle said:
You can do this by adding a Tab Control onto a form. Look in the toolbox for
the icon that looks like a stack of folders. Drag this onto your form and
you should be in business.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Greg said:
When I use the form wizard I have options of Columnar, Tabular and
Datasheet. I am interested in creating a different format. The format
looks like a series of folders with Tab Identifiers.
I would like this format to direct user to different forms. Or to
sometimes use as a way to use this "tab type form" to update many
fields within the same record- table.
Or use this "tab type form" to replace the form/subform capabilities.
I am interested in your thoughts if this is doable and how?
I have seen in Help a way to add what I am looking for to an existing
form.

Thank You,
Greg
 
You can start in design mode, when asked what table (usually bottom left
side) select the table you want. If need be, add subforms to your orginal
form to include other tables.
 
Sure - to select the table or query just select the form (Edit->Select Form)
or click the square at the top left corner of the form design window. Then
open the property sheet and look under the 'Data' tab. Use the "Record
Source" property to select the table or query for your form.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Greg said:
Sandra,
Thank You. Can I start with a blank form in Design mode ?
How do I the select the table I would like to use to build the fields
to go on tab 1 and tab 2?
Thank You,
Greg Jesky


Sandra Daigle said:
You can do this by adding a Tab Control onto a form. Look in the
toolbox for the icon that looks like a stack of folders. Drag this
onto your form and you should be in business.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Greg said:
When I use the form wizard I have options of Columnar, Tabular and
Datasheet. I am interested in creating a different format. The
format looks like a series of folders with Tab Identifiers.
I would like this format to direct user to different forms. Or to
sometimes use as a way to use this "tab type form" to update many
fields within the same record- table.
Or use this "tab type form" to replace the form/subform
capabilities. I am interested in your thoughts if this is doable
and how?
I have seen in Help a way to add what I am looking for to an
existing form.

Thank You,
Greg
 
Sandra and Sandi ,
Thank You both,
Sandra your suggestions were right on.
Thanks again,
Greg
Sandra Daigle said:
Sure - to select the table or query just select the form (Edit->Select Form)
or click the square at the top left corner of the form design window. Then
open the property sheet and look under the 'Data' tab. Use the "Record
Source" property to select the table or query for your form.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.


Greg said:
Sandra,
Thank You. Can I start with a blank form in Design mode ?
How do I the select the table I would like to use to build the fields
to go on tab 1 and tab 2?
Thank You,
Greg Jesky


Sandra Daigle said:
You can do this by adding a Tab Control onto a form. Look in the
toolbox for the icon that looks like a stack of folders. Drag this
onto your form and you should be in business.

--
Sandra Daigle [Microsoft Access MVP]
Please post all replies to the newsgroup.

Greg Jesky wrote:
When I use the form wizard I have options of Columnar, Tabular and
Datasheet. I am interested in creating a different format. The
format looks like a series of folders with Tab Identifiers.
I would like this format to direct user to different forms. Or to
sometimes use as a way to use this "tab type form" to update many
fields within the same record- table.
Or use this "tab type form" to replace the form/subform
capabilities. I am interested in your thoughts if this is doable
and how?
I have seen in Help a way to add what I am looking for to an
existing form.

Thank You,
Greg
 
Back
Top