Access 2000 SubForm Problem...

[Skates]

I am having problem linking data in a form to a subform.

What I have is a form that contains the name of a project and the description of the project. That form then includes a subform that lists the various progress reports for that project in a tabular form.

I have a database to keep track of the link between the project and the various progress reports that it can contain. My problem is when using the Form/Subform to create new progress reports, it is not creating the necessary values in the table to link the project and the new progress report together. Any help would be appreciated!

Here's a screenshot to give everyone a better idea:

TIA!

[comteck]

I'm having trouble seeing the screenshots. However, I will make a suggestion.

First of all, open the properties on the main form, and ensure that your "Record Source" matches the main table that you want to use for the main form, and on the subform, ensure that the "Record Source" matches its table.

Secondly, open the properties on the subform, and ensure that the "Link Child Fields" and "Link Master Fields" are the same (they normally have an "ID" on the end as well, but it's not necessary). Even though these 2 properties might show the same values, it still may be incorrect. While still in the properties for the subform, click on either the "Link Child Fields" or "Link Mater Fields", and you will notice 3 little dots on the right. Click on the 3 dots, and another window opens up. Open the pull-down box for the Master Field, and ensure that the field is from the table that is used for the main form, and not for the subform. Since they both have the same name, they might be reversed. Check the Child Field as well to ensure that it's from the table used for the subform.

Good Luck.