How to Create a Subform in Microsoft Access

Supriti Tripathy

19th Jul'21
How to Create a Subform in Microsoft Access | OpenGrowth

Microsoft Access is one of the best database management systems offered by Microsoft. Tables, Queries, Forms, Reports, and many such specific commands allow users to add, edit, display, or delete items within the database. Forms give us accessibility to the data stored in the database. SubForm is a Form within a Form. It is created to provide more insight into the data saved in the Form.

To understand the relationship between a subform and a form, let's look at an example. Suppose we have a form that displays a company and a subform that shows every employee within the company.

Another example would be an order in a form, a subform would have all the order items. The need to create a subform is when we want to display data from multiple tables in a one-to-many relationship. Here, to show order with the order details, the creation of a subform is necessary.

 

create subform

 

Step by Step Approach to create a subform

 

Step 1 : Go to the Form

Here, on the left navigation pane, right-click and select the option "Design View".

 

Step 2 : Go to the Controls Toolbar

You can find the Controls Toolbar in the Design tab. Click on the down arrow to expand the Controls toolbar.

 

Step 3 : Click on the Subform/Subreport option.

Now you can drag the Subform and place it in the main Form.

 

Step 4 : Verify

Now click on the exact location of the main Form where you want the Subform to be set up. The Subform is launched, and you get a pop-up if you wish to use the same Form or create a new form using tables or queries.

 

Step 5 : Navigate

Once you make the selection, click on the Next option. Select the table and query from the drop-down menu. Now select each field you want to display in your Subform and click on the > button to move the selected fields to the right pane. Move on to the next table or query and select fields if you want to display them.

 

Step 6 : Link

In this step, Access asks you to link the main Form with the Subform. Based on the primary key and foreign key relationship set up by you, there will be a field recognized by Access. You can also choose the option "Define my own" and choose a field. Click the Next button.

 

subform

 

Step 7: Create

Give a name to your Subform and click on the Finish button. It creates a subform in the location set up at Step 4 in Access and adds it to the main Form. In the Design view, it appears like a big encapsulated form.

 

Step 8 : Make Edits

If you need to edit specific sections like font, colours, label, you can switch to Layout view, edit, and go back to the Design view and get the minor modification done. You can switch to the Form View to see how the forms are displayed to the user. The main Form is seen and embedded within is the Subform with the table and query results. The data in the Subform updates itself as you move through the main Form.

 

Step 9 : Save the Subform

The Subform is saved as a separate form. You can view the saved Subform in the Navigation pane. It appears as an independent form and opens in the Datasheet view. As you open it, it displays all data. When you open it after opening the main Form to which it is linked, it only shows the main Form's data.

 

A Simple Illustration

Let us assume that the Order table is created with the following fields

Order Id

Order Date

Order Amount

Customer Id

 

And Customer table is created with the following fields

Customer Id

Name

Address

Contact

 

  • Now, it must establish a relationship between these two tables. It is one-to-many as one customer can place many orders.
  • Select the Customer table, click on Design---Subform in the controls group of the tab. Extend the Form for the order list.
  • Select the Orders table and click Next.
  • The Subform Wiz will show the two tables as related via one field, i.e. Customer Id.
  • Click Next. Give a name to the Subform, say XYZ, and click Finish.
  • Change the view to Layout View. The result shows all the orders for each customer.

 

Conclusion

As we see, it is effortless to create subforms in MS Access. From Customizing Your Start Menu to providing records of data stored, Microsoft has a lot to offer. MS Access helps in displaying large amounts of data and also avoids confusion for the user. You must use this feature and test with varying data fields. Isn't the impact of technology over human lives commendable? 

 

We at, OpenGrowth, are committed to keeping you updated with the best content on the latest trendy topics from any major field. Also, both your feedback and suggestions are valuable to us. So, do share them in the comment section below.

A believer of good things and pursuer of diverse avocation, she is a fiction lover and a simple writer. Supriti has a number of professions to her list and she feels challenges are the only answers to failures.

Comments

Blank User| OpenGrowth

Albertwalker922@gmail.com

6th Jan'23 02:26:07 PM

Good day to all viewer online, my name is Albert Walker I am so overwhelmed sharing this great testimony on how i was checking for solution in the internet while miraculously i came across Dr Kachi who brought my ex Girlfriend back to me, This is the reason why i have taken it upon myself to thank this great spell caster called Dr Kachi, because through his help my life became more filled with love and i am happy to say that my ex Girlfriend who has been separated from me for the past 2years came back to me pleading for me to accept her back, This was a shocking to me my partner is very stable, faithful and closer to me than before, because before i contacted Dr Kachi i was the one begging my ex Girlfriend to come back to me but through the assistance of Dr Kachi, I now have my relationship restored. You can also have a better relationship only if you Contact Dr Kachi Website, https://drkachispellcast.wixsite.com/my-site OR Email: drkachispellcast@gmail.com You can reach him Call and Text Number:+1 (209) 893-8075

Blank User| OpenGrowth

thomasgibson802@gmail.com

11th Dec'22 10:15:07 AM

I want to use this opportunity to tell the whole world on how I become rich and famous. I’m 93 years old. I was passing through difficulty in business and there was no hope of me coming out of my debt. I borrow money in my bank to do my business and I run at lost on the business I got frustrated and decided to be playing lottery to see if I can win and make my business grow and I have played for years now nothing good is coming my way on till I meet someone online talking about Dr Ayoola on the internet. He was taking about how this Dr Ayoola help him to win mega million lottery game. I said to myself if this is true and decide to contact him and told him to help me as well I later read more about this man and see how he has been helping people all over the world. I have faith in him and choose to work with him. After working with him he told me what I need to do for the number to be given to me which I did after he finish working he said I will have a dream and the number will be review to me in the dream. That night has I was sleeping I dream a number immediately he call me and gave me the same number I dream of and ask me to go and play the number. Today I’m here testifying of the good work he did for me I played the number and I won the sum of 1, 000,000 million dollars in a lotto max. You can contact Dr Ayoola for help if you want to win big in lottery game he has the gift of giving right number contact him today and thank me email him today Via email: drayoolasolutionhome@gmail. com or https://www.facebook.com/Dr-Ayoola-105640401516053/ text or call +14809032128

Blank User| OpenGrowth

Evelyndawson886@gmail.com

11th Dec'22 07:34:28 AM

I was reading through Facebook when I saw a post about the legit spell caster called Dr Kachi who has helped people in winning the lottery ticket. I'm a woman who’s addicted playing the lottery and always put all my faith in buying the ticket I lost all my money of all time and my effort trying to win my game, until I met my old friend who told me the Secret of her wealth that Dr Kachi who cast lottery spell winning number for her to play the Powerball ticket that change her life, it was she that directed me to Dr Kachi. i explained to him i want to win the Mega millions, Dr Kachi instructed me on what to do which i did and he told me to wait 24hours for him to cast the winning numbers, i went to buy my ticket and play the numbers which Dr Kachi gave to me and it was surprise when i find out i won the sum of ($109.9 Million Dollars Cash Value) for Friday night's drawing Mega Million Jackpot and than the whole thing looks wonderful, That's the most amazing thing i have ever experience with winning the lottery spell. i believed him and today i am glad to let you all know that this spell caster have the power to help you win big amount in lottery game, because i am now happy with my life. words Ain't enough to say thank you Sir. and from the deepest part of my heart, i will show my gratitude by sharing this testimony all over the world let people seek for your help to win the Lotto Game, and be happy like me today: Text Number and Call: +1 (209) 893-8075 Email: drkachispellcast@gmail.com his Website: https://drkachispellcast.wixsite.com/my-site

Blank User| OpenGrowth

thomasgibson802@gmail.com

21st Nov'22 11:52:27 PM

I want to use this opportunity to tell the whole world on how I become rich and famous. I’m 93 years old. I was passing through difficulty in business and there was no hope of me coming out of my debt. I borrow money in my bank to do my business and I run at lost on the business I got frustrated and decided to be playing lottery to see if I can win and make my business grow and I have played for years now nothing good is coming my way on till I meet someone online talking about Dr Ayoola on the internet. He was taking about how this Dr Ayoola help him to win mega million lottery game. I said to myself if this is true and decide to contact him and told him to help me as well I later read more about this man and see how he has been helping people all over the world. I have faith in him and choose to work with him. After working with him he told me what I need to do for the number to be given to me which I did after he finish working he said I will have a dream and the number will be review to me in the dream. That night has I was sleeping I dream a number immediately he call me and gave me the same number I dream of and ask me to go and play the number. Today I’m here testifying of the good work he did for me I played the number and I won the sum of 1, 000,000 million dollars in a lotto max. You can contact Dr Ayoola for help if you want to win big in lottery game he has the gift of giving right number contact him today and thank me email him today Via email: drayoolasolutionhome@gmail. com or https://www.facebook.com/Dr-Ayoola-105640401516053/ text or call +14809032128

Blank User| OpenGrowth

hakaungamaxwell@gmail.com

19th Nov'22 07:54:35 PM

I use to be a very poor man who has always not find luck when it comes to playing the lottery. I have been playing lottery since i was 21 years and now i am 45 meaning i have been playing lottery for 24 years. The biggest amount i have ever won in my life was 400 dollars. But one day my story turns to history after i find this man called Dr Ayoola on the Internet that he is the best when it comes to winning lottery. This man is a very strong voodoo man who gives out the numbers that can never fail. After all my years of laboring and struggling to win the lottery i finally won ( $27,000,000) Dr Ayoola is the name, Email: drayoolasolutionhome@gmail.com or contact him on his whatsApp number text or call +14809032128 this is the only way to win the lottery and the best way OR https://www.facebook.com/Dr-Ayoola-105640401516053/

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:44 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:44 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:43 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:43 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:42 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:42 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:42 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:41 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:41 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

DARKWEBONLINEHACKERS@GMAIL.COM

7th Oct'22 11:01:40 PM

GET RICH WITH BLANK ATM CARD, Whatsapp: +18033921735 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so many testimony about how Dark Web Cyber hackers send them the atm blank card and use it to collect money in any atm machine and become rich. {DARKWEBONLINEHACKERS@GMAIL.COM} I email them also and they sent me the blank atm card. I have use it to get 500,000 dollars. withdraw the maximum of 5,000 USD daily. Dark Web is giving out the card just to help the poor. Hack and take money directly from any atm machine vault with the use of atm programmed card which runs in automatic mode. You can also contact them for the service below * Western Union/MoneyGram Transfer * Bank Transfer * PayPal / Skrill Transfer * Crypto Mining * CashApp Transfer * Bitcoin Loans * Recover Stolen/Missing Crypto/Funds/Assets Email: darkwebonlinehackers@gmail.com Text & Call or WhatsApp: +18033921735 WEBSITE: https://darkwebonlinehackers.com

Blank User| OpenGrowth

robertmorrison744@gmail.com

5th Sep'22 03:59:09 PM

READ MY REVIEW HOW I WIN $158m CONTACT DR KACHI NOW FOR YOUR OWN LOTTERY WINNING NUMBERS. I was a gas station truck driver and I always playing the SUPER LOTTO GAME, I’m here to express my gratitude for the wonderful thing that Dr Kachi did for me, Have anybody hear of the professional great spell caster who help people to win Lottery and clear all your debt and buy yourself a home and also have a comfortable life living. Dr Kachi Lottery spell casting is wonders and work very fast. He helped me with lucky numbers to win a big money that changed my life and my family. Recently i won, ONE HUNDRED AND FIFTY EIGHT MILLIONS DOLLARS, A Super Lotto ticket I bought in Oxnard Liquor Store, I am so grateful to meet Dr Kachi on internet for helping me to win the lottery and if you also need his help, email him at: drkachispellcast@gmail.com and he will also help you as well to win and make you happy like me today. His WhatsApp number: +1 (570) 775-3362 visit his Website, https://drkachispellcast.wixsite.com/my-site

Blank User| OpenGrowth

benito

8th Jun'22 02:03:19 PM

If you want to get rich within 24hours to 48hours with a programmed blank atm card, It all depends on how fast you can be to get the new PROGRAMMED blank ATM card that is capable of hacking into any ATM machine,anywhere in the world. I got to know about this BLANK ATM CARD when I was searching for job online about a month ago..It has really changed my life for good and now I can say I’m rich and I can never be poor again. The least money I get in a day with it is about $50,000.(fifty thousand USD) and i only spent $250 to get the card.Only serious individuals should contact him because he is very straight forward if you don’t have the money don't even bother to contact him and his series is 100% trusted i am a living testimony. Every now and then I keeping pumping money into my account. Though is illegal,there is no risk of being caught ,because it has been programmed in such a way that it is not traceable,it also has a technique that makes it impossible for the CCTVs to detect you..For details on how to get yours today, email: oscarwhitehackersworld@gmail.com tell your loved once too, and start to live large whatsapp..+1(510)-777-9243

Blank User| OpenGrowth

Blank ATM Card +393512615163

19th May'22 10:40:40 PM

Get $5,500 USD every day, for six months! See how it works. What'sApp : +393512615163 I want to testify about Dark Web blank atm cards which can withdraw money from any atm machines around the world. I was very poor before and have no job. I saw so much testimony about how Dark Web hackers send them the atm blank card and use it to collect money in any atm machine and become rich. Email : carolblankatmcard@gmail.com Hangout : carolblankatmcard@gmail.com What'sApp : +393512615163 They also sent me the blank atm card. I have used it to get 90,000 dollars. withdraw the maximum of 5,000 USD daily. The Dark Web is giving out cards just to help the poor. Hack and take money directly from any atm machine vault with the use of an atm programmed card which runs in automatic mode.