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
Fritz PaulAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

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?
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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 Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Fritz PaulAuthor Commented:
Thanks, I fully understand now.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.