How to construct the example form.

Posted on 2014-08-18
Last Modified: 2014-08-18
I attach an empty database for Property Management.
I got the template for it somewhere.
I am trying to understand it.
On form "Property Details", there are two tabbed forms, "General" and "Lease". See screenshots below.
The source for tab "General" is actually the same as the source for "Property Details", but "Lease" has its own source and is the "Lease Subform".
Can you explain how this form was constructed so that it has these two tabbed tabs.
One thing that I specifically not understand is that "general" is not a subform. Or is it?
I do not have a problem with the contols and macro's. Only directions or steps how I can recreate the form. I understand forms with one or more subforms.
Property Details GeneralProperty Details LeaseProperty-management-Example-from-templat
Question by:Fritz Paul
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    <<Can you explain how this form was constructed so that it has these two tabbed tabs.
    One thing that I specifically not understand is that "general" is not a subform. Or is it?>>

      That's it exactly.   The general tab contains controls that belong to the main form.   The Lease tab has a sub form control on it, that contains a separate form and controls within that.

     Because it is a form separate form from the main form, it has its own record source, events, and properties.


    Author Comment

    by:Fritz Paul
    Hi Jim,

    I just can't get it right.

    Could you give me steps to follow to get the general form on a tab please.

    I can create a blank form and then add a tabed form with a subform with the "property details" on one of the tabs.

    My problem is that when I create a "Property Form" access already places all the controls on that form. How to get it on the tabbed form?
    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    1. Select the controls.

    2. Cut.

    3. Select the tab of the tab control you wish to place the controls on.

    4. Select paste.

      That put's all the controls on the tab.

    LVL 56

    Accepted Solution

    and just to be clear; if the controls are in a subform, you do nothing with those.  

    It's the subform *control* on the main form that you cut and paste.   All the controls within a subform are encapsulated within the subform.

     You can tell when you have a subform by looking for the square in the upper left (look at your 2nd screenshot).  Note also that you see a form header and detail band in the view (contrast that to the 1st screen shot).

     To select the control, click anywhere in the main form so that nothing is selected.   Then drag the cursor over the border of the subform control.  It will be selected and you can confirm that by looking at the property sheet (Alt/Enter if it's not up).

      You can also do a single click, but it's easy to double click and "move into" the subform for editing (this was added as a feature and while it's nice, it does cause a lot of confusion).

      Note another way to select a control if your having problems is to use the drop down on the ribbon.  This is only really helpful when you've named your controls.

      Another way is to select any control and then tab or shift tab through each control on the form.  This can be helpful when one control is behind another and you can't click on it.


    Author Closing Comment

    by:Fritz Paul
    Thanks, I fully understand now.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    This isn't a frequent question on EE. I must have seen it three or four times (among several thousand questions). However, I use this trick quite often, most frequently as a delayed Current event. A form does not expose it's calculation dependenc…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now