Subforms

[stc]

Hi,

Being relatively new to Access 97, I have a problem that is driving me crazy, but which is probably straightforward. In an existing database of customer details, I want to add a subform (in the shape of a tab) to the main record page. This subform will show the details of a particular product. I would like to be able to cycle through the various companies and have the subform display the product information for each company. I have set up a table for the product details, and a query to get those details. I have then set up a new form which will display the results of the query. However, I am having problems keeping the product details unique to particular records. I also want to be able to add new details directly onto the subform, but when I do this, they appear in all records.

Any help appreciated...

 

[Darrylles]

Hi Mark,

Have you set the 'Link Child Field' and 'Link Master Field' properties (in the Data tab of the Subform properties) to the correct fields to tie the records together?

Also, have you got a relationship between the Customer and the Product tables?

Look at Access help on 'sub-forms' for a detailed explanation.

Regards

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience."