MS Access Passing Data in Forms

[instructor]

I have an Access database where I am trying to use a form with subforms. There are 3 tables linked to one another. After I have created the form with the two subforms, everything works fine (all data is correctly showing in all forms). However, when I go back to the main form to locate a record to update, the subforms don't bring up any data. The subforms are blank. Why does it work when first opened (all forms are correct), but when searching for a specific record, the other two forms don't show data.

I am a novice programmer but willing to learn. Any help is very much appreciated.

[twinnyfo]

Do you have the proper Master-Child relationships established with your subforms? You have not provided a lot of information, so we have to guess as to what the problem may be.

[instructor]

Yes, all tables are appropriately related.

[twinnyfo]

But, have those relationships been properly applied to the Forms/SubForms? When two tables are related by a common Primary Key, and those tables are properly configured on Forms, when the master Table moves to a new record, the subforms should automatically filter by only the related PK. Your problem "sounds" like a Master-Child issue on the Forms--not between the tables.

[zmbd]

Here,
try this example:Create a form that contains a subform

The relationships must be setup at both the table and the form levels. Although similar, the relationships at each level serve different purposes.