• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

How to construct the example form.

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
0
Fritz Paul
Asked:
Fritz Paul
  • 3
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<<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.

Jim.
0
 
Fritz PaulAuthor Commented:
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?
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.

Jim.
0
 
Fritz PaulAuthor Commented:
Thanks, I fully understand now.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now