I have a Main form one sub form the main form is relate to Employees table Employee No.(PK) one sub form in sub form have two tab controls one is family details another is Department details family details is related to family table and Department details in Department table Now problems is when I go to see the Employees details in Main form I want particulars employee no. family, department details in sub form in Main form I write the one particular fields on exit event like below

Private Sub cmbCF_Exit(Cancel As Integer)
DoCmd.OpenForm ("subFrm")
End Sub

What I want to do write code in Main form to see particular employee no. family, department details in sub form


Mohamed Mohiddin
Officer

__________________
Mohamed Mohiddin
Officer

To access subform objects in the main form's Project, try one of the following:

Me("Subform Name").Form.[Object Name].Value

Form("Subform Name").Form.[Object Name].Value