Add a Subform in Access 2007

The main form in Access 2007 may have another form inserted into it called a subform. The combination of form and subform may be called a hierarchical form, master/detail form or parent/child form. Subforms are most commonly used to show data with a one-to-many relationship. The following steps will show how to add a subform in Access 2007.

Sponsored Links:

Related Topics

Subform goes out of touch when its table is edited?
I have an Access 2007 subform linked to the mainfor, and they were both working fine. it linked on the proper parent/child link, edits on the subform tracked the proper parent record, etc. etc.

Then I edited the table bound to the subform simply to make one of its text fields longer; that's all!

Now, data from the subform table does not show up in the subform at all.

I can still add a new record via the subform, but I will only be able to see it briefly (while initially entering it). if I go to a different mainform record and then return to the one that should have the new subtable record, again, it doesn't show.

However, looking directly at the table for the subform shows that the new record (and the old ones) are indeed still allproperly there in their table.


Getting the Max() date from a SubForm Access 2007
I have a little problems well 2 problems in fact

I have a form and the technician need to use a subform in this form to add items on the order, and for each items there is a given delivery date. What I want is for a textbox on the form(not the subform) to get the Highest date from the subform

My subform is called : SF_Materiaux and the field in the subform is called : Livraison_Prevu

Sorry for those french name lol
I had a textbox whose source is =[SF_Materiaux].[Formulaire]![Livraison_Prevu]
and it gives me the first date from the subform and If I had Max() before it it gives me #error anyone can help ?


Restricting SubForm to One Record Entry Per Parent: Access 2007
I have a one-to-one relationship between two table. I have successfully added the subform, but I get the option to add additional child records in the Datasheet View. This means that when a user tabs to the next row and enters data they get an error--and they should.

Question: How do I restrict the subform to show only one row in Datasheet View?


Access Runtime 2007 Com Add-In
I currently have a Dell Precision T3500, with Windows 7, Office 2010 Professional. On my computer I have Adobe Standard 9. With Adobe Standard 9 it has a Com Add-in for Microsoft Office PDFMaker.

One of the applications our business uses, is tied to Access Runtime 2007.

In the Application when you go to view a report it doesn't load correctly. I have isolated it to the Com Add-in. All of our computers running Office 2007 Professional, I loaded the Microsoft Office Access 2007 and turned the Com Add-in to inactive. This fixed all those computers.

However, on my own computer with the above stated software. I turned the Add-in to inactive in office 2010 and the Com Add-in still loads in Access 2007 Runtime when I load it.

So my question is how do you Inactive/Disable a Com Add-in in Access 2007 with only Runtime installed?


Junction table in subform in Access 2007
INSTRUMENTAL-PART Table (e.g. Flute 1, Flute 2)
MUSICAL-PUBLICATION Table (including musical titles)
JUNCTION Table subordinate to both the other tables

The form displays the rows in a subform. I need the subform rows to include musical titles from. The users would not be permitted to perform updates in the subform. Hopefully this is possible in MS Access 2007.


Subforms and refreshing data in other subforms from ANOTHER subform....
I have a form with 3 subforms. Subform 1 is for adding records. Subforms 2 and 3 are for editing/viewing records. Since 2 and 3 are essentially identical, we will focus only on subforms 1 & 2 for solutions.

What I want to do is add a record in subform 1, and then be able to immediately view that record in subform 2. However, whenever I add a record in subform 1, I do not see it when I click over to subform 2.


How to add controls on subform
As soon as I like to add any control on subform it stays on main form but not on subform, is there any property I need to change


How to add controls on subform
As soon as I like to add any control on subform it stays on main form but not on subform, is there any property I need to change ?


Setting focus on a new record in subform
I have a main form with a button add and a subform which is bounded to a given table.I want the add button to work like this:

When add button is clicked, It has to set focus on the first column of the new record in the subform and then after the user enters data into all the columns in the subform , after entering the last value and pressing enter it must automatically load this into the table.


How to add a total in a datasheet (Access 2000)?
I know there is a feature in Access 2007 but I'm using Access 2000 (and am bound to it by my company).

I have a subform (based on a query) which displays four columns of figures. I need to add a total to the bottom. How do I do this? My data appears as follows:

store.item1.item2.item3.item 4

I've read that it can be done with VBA but I can't find any further information on how it is done


Add Subform to Report
I'm trying to add a subform to a report. I know how to use the subform/subreport control, but it pulls up the subreport wizard when I really want to add a subform. Is it possible to add asubform as opposed to a subreport into a report?


Subform wont show in 2007
I have a form with a subform I created in 2010 and subform will not show in 2007 with sp2 anyone know why


How to show new record at the top of a subform
I have a database in access 2007. The main form has a subform and I would like a blank new record as the first record of a subform. Is there a way to do that without making two separate subforms (one for a blank new record subform and the other for records that already exist


Subform Help
I am new to access and have been tasked with working on a new database. The database is for case management and I am trying to build a new case form. I created a navigation form with a totalof four left buttons; "case information,"

I would like a different subform inside the navigation window when a button is click, basically embed the respective subform. For example, the subform to contain the when and what part and the complete to have a button to submit or add additional subjects.

When I right click the subform area and select "build" I am able to add a subform. However, after doing so it disappears as soon as I change from design view.


Display subform total
I have an Access 2007 single form with subform. The subform has a hidden textbox that sums a record in the subform and displays in a textbox on the form. The form textbox is blank, but becomes visible if I click on the taskbar or open another app. If I update the subform or move to another record, I loose it again. I've tried requery and recalc on practually every event of the form, subform and both textboxes to no avail. What will make this textbox stay visible?


Access 2007 - only starts in safe mode
Access 2007 will no longer start unless in safe mode, and I have uninstalled, reinstalled, used the MSFT Office 2007 removal tool, removed add-ins, went into registry and manually removed everything relating to Office 2007, and still, no matter what, Access 2007 crashes unless using Safe Mode.

There are NO add-ins when I open it in Safe mode, nothing. I've spent over 5 hours trying to get it to work, and after all these years of working in MS Access with only a few hiccups...


Creating Managed Add-ins for Access 2007
Learn how you can extend Access 2007 by creating and incorporating managed add-ins into your applications. This article demonstrates how to create a simple add-in that consumes data returned from a Web service, by using the Visual Studio Shared Add-in template.
You can use Access 2007 support for managed add-ins to create cross-application tools, as many software vendors will. But, that is not the most likely scenario: Most likely, you will use add-ins to supplement your VBA code, and to gain access to the rich .NET Framework environment. If there are tasks you want to accomplish that are easier in managed code, Access support for managed add-ins is a perfect solution: You get the unmatched Access form and report designers, and the power of Visual Studio and the .NET Framework when writing code. You can extend Access 2007 in ways that were previously difficult (if not impossible) by creating and incorporating managed add-ins into your applications.


Primary key not transferring to FK on subform?
For some reason when I add records to a subform the master field ID from the parent form does not transfer to the subform and add it to the table?

Main form PK: EmployeeID
Subform FK: EmployeeID

After I add events on the subform, the FK doesn't populate at all and when you go back to the record the items you have entered are gone. When you check the table, the entries are there, just missing the EmployeeID field?

I know it's something simple that I am overlooking, any help is greatly appreciated. Thanks.

On the subform, Link Master Fields and Link Child Fields are both set to EmployeeID.


Form/Subforms not allowing new record addition and not showing all records
I have a form with two subforms in Access 2007. The main form is for the contact information (i.e. address, phone, etc.) Subform 1 is to track whether they get certain services Subform 2 tracks a contact's account number or numbers. I want all contacts to show in the form but right now only contacts that have services and account numbers (i.e. something filled in, in each subform) are what is showing and it won't allow me to add a new record. Any suggestions on how to fix this so that I can add a new record and have all contacts showing whether they have something in the subforms or not


Cant edit subform of a subform
Hoping someone can help with what I need to do to allow the following to work:

I have a main formlinked to a subform, within the subform, I have a second subform.

I am able to edit and add data in the main form, and the first subform. I am not able to edit or enter data into the second subform.

If I open the first subform directly without going into the main form, I have no problem entering data into the second subform.

All the properties are set to allow edits, allow additions, allow deletions