selecting a record based on value in a combo box

[Nasirali1]

I have two tables. One of the table contains data on the individual while the other table has data on the organization/corporation. I have created combo box on the main form to select the organization/corporation with which the individual is associated. Now I would like to open a sub-form (using the open form command button) to display data of the organization/corporation I have selected in the combo box. Any help will be much appreciated.

[PhilOfWalton]

Bit thin on information, so I shall make the following assumptions.

In your table of individuals you have a Foreign Key pointing to the Organisation to which the individual belongs.
Your main form is for the individual and you are using a Combo Box to select the appropriate organisation.
The Primary Key for the Organisation table is "OrganisationID " and the foreign key in the Individual table is also "OrganisationID "
The Combo Box is Bound to OrganisationID in the Individual Table.

Having created your subform ("SubOrganisati on") based on the organisation, drag it onto the main form and set the LinkMasterField s & LinkChildField to "OrganisationID "

On the After Update of the Combo box, you need to refresh the subform so use something like this

Private Sub OrganisationID_AfterUpdate
    SubOrganisation.Requery
End Sub
 

There are other alternatives methods without using a subform as well.

Phil

[NeoPa]

If you're opening a form on the click of a button it's almost certainly NOT a sub-form (See Referring to Items on a Sub-Form).

To use a ComboBox control to help you filter from the existing data such that you can find a particular record more easily have a look at Cascaded Form Filtering or some of its linked pages.