Synchronizing Sub-Forms

[minez50]

Hi, Could anyone please help me!

I am trying to create a sub-form which achieves the following.

When you select a vendor from a combo-box, only the software that is manufactured by that vendor appears in a data-sheet form view.

I have tried to create a secondary form which shows all the software and saved this. And then created another main form which has a combo-box for listing and selecting a software vendor. I have then dragged the secondary form into an area of the main form. Now i am just trying to figure out how to synchronize the two forms so that when you select a vendor, only software manufactured by the vendor is shown.

 

[ansentry]

Have a look at the attached sample, have a look at the code behind the "First" subform.

 

[minez50]

Although your first sub form uses a similar concept, what i am trying to do is slightly different. I have a table called Software. In this table are various fields that identify a Application ID, Application name, vendor, software type etc.

I have created a 1st form which shows the application name and the software type fields of the Software table.

In the Main form, I have created a combo box which lists all the different vendors. These are originally held in a vendors table and have a foreign key link in the software table. I have dragged the 1st form into the main form.

Now when I select a vendor, from the list box, such as 'Microsoft', the 1st form held in the main form should automatically update to show all software and its software type for only Microsoft Applications.

Does anyone know how exactly I would achieve this?

 

[RuralGuy]

Have you set up the LinkChild/MasterFields properly? Done correctly, everything you want to happen will happen.