Re: need help,,,,

From: Sprinks (Sprinks_at_discussions.microsoft.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 08:19:07 -0800

Hi, Bashar.

Subforms are used primarily to display the many side of a one-to-many
relationship, such as Customers and Orders, but are also useful in dividing a
business function into manageable process "chunks", which sounds like what
you're trying to do. Then the user can concentrate on a single task
efficiently--you can put each task or series of tasks on a single tab.

I'm assuming that all of these forms have some common field such as
OrderNumber, or CustomerNumber, etc. that you can link them to the main form
by.

A Tab is simply another control; place it just as you would any other
control into the Detail section, however, start from a blank form. It looks
like a file folder on the Toolbox toolbar. Insert as many tabs as you like,
and set their Name (how to refer to the page in VBA) and Caption (what is
displayed on the tab to the user) properties.

On the first tab, place the desired fields for your main form. Be sure that
the linking field is part of the form's RecordSource, although you needn't
display it on the form.

Assuming the other forms are created, resize your edit window so that you
have access to the Database window, and drag the forms from the Forms tab and
drop them onto the appropriate tabbed page. If you have Wizards enabled,
Access will guess what the linking field is, if not, or if Access guesses
wrong, you can set it by changing the LinkMasterField and LinkChildField
properties of the subform.

What I often do is place all common information from the forms, or any
totals I wish to display in the form header or footer so that it is visible
from any tabbed page. This gives the form a consistent look, maximizes
access to information, and minimizes the number of editable fields per page.

Good luck. Hope that helps.
Sprinks

"Bashar" wrote:

> Hi Sprinks
>
> Please tell me how can I use a single tabbed form, with subforms placed
> on each tab? in my project.
>
> Best Wishes,
>
>

Relevant Pages

  • Re: Displaying a "Please wait..." Form
    ... Another thing you might want to consider is to limit the number of subforms ... separate subforms on each tab. ... I have found that you can use a tab control, ... but get away with having only a single subform that you display over the ...
    (microsoft.public.access.formscoding)
  • Re: Synchronizing forms and autolookup in the case of 1-to-1 relations
    ... An alternative approach might be to use subforms for the related records. ... You might do this as a tab control, where the first tab page shows the primary record from the main table, and each other tab pages show the fields for one of the subtypes. ... To make things easier for the user I want the specific forms to display some ...
    (microsoft.public.access.formscoding)
  • RE: Displaying more than 1 table in a form in access without subforms
    ... You should use subforms if you need to display table details in each tab. ... > If subforms can be designed so that I can re-arrange them in a different way ...
    (microsoft.public.access.forms)
  • Re: Subforms - is this possible?
    ... Then I create separate forms which I want to use as subforms for main form. ... Now I open main form, activate 2nd tab of it, and drag first subform from ... > I'm putting together a contacts database for our business. ... > On the right I would like to display one of a number of choices, ...
    (microsoft.public.access.forms)
  • Re: W07: How to turn table gridlines on or off _without_ there being a table present ...
    ... No, much of what is on the Developer tab is actually in quite frequent demand, which makes you wonder why it isn't just displayed by default. ... Microsoft MVP (Word) ... But instead of the check box to display it being on the Advanced tab of Tools | Options, ... table gridlines by default. ...
    (microsoft.public.word.newusers)
Loading