Sub-Form Question

[amcglone]

I have created a table that I would like to use to populate information in a sub-form. The sub-form may have multiple entries from the table, but will never include all of them. I am not sure what I am doing wrong, but when I am dropping the sub-form onto the existing form, it is pulling all of the information from the table instead of parts of it.

[Datagopherdan]

You need to link the master and child fields between the main form and the sub-form. I'm assuming it's a one to many relationship between the data source in the main form and the data source in the sub-form. Let's say that the relationship is set between a field called MainID in the main form's data source and a field called SubID in the sub-form's record source. Go to the sub-sub-form's properties and under the data tab, you'll see "Link to Master Fields", click on that and from there you can set the relationship.

I have created a table that I would like to use to populate information in a sub-form. The sub-form may have multiple entries from the table, but will never include all of them. I am not sure what I am doing wrong, but when I am dropping the sub-form onto the existing form, it is pulling all of the information from the table instead of parts of it.

[ConneXionLost]

Since you only appear to mention "one" table, Dan's assumption:

... I'm assuming it's a one to many relationship between the data source in the main form and the data source in the sub-form. ...

needs your validation. Please confirm you are using two joined tables as a basis for your form/sub-form development.

Cheers,