I have one main form and one sub form the main form is related to main table and sub form is they have two tab control one is family details another is Dues details In main table Eno is (PK) Family table, Dues table related to main table I write the In main form one field on Exit event is below like
Private Sub cmbCF_Exit(Cancel As Integer)
DoCmd.OpenForm ("subFrm1")
End Sub
Now problems is In Main form when I exit the field the subFrm1 always show the first records details actually I want when I change next records in main form the subFrm1 should show the next records in Family, Dues table details How should write the code and what event to be write



Mohamed Mohiddin
Officer

__________________
Mohamed Mohiddin
Officer

Mohiddin52
Hi

I am not sure why you want to write special code to link the Dues Detail form to the Main form

If the sub forms record source is the related dues table then you should "embed" the sub form in the main form.

Just drag the sub form on to the main form in Design view and follow instructions.

It is then only necessary to find the Named Person in the Main form and all of the "Dues Details" will be shown in the sub form

The sub form should be in most cases preferably in tabluar layout

Hope this helps

Also, if you go to the sub form's Properties dialog box when it is in design view and in the main form, select the Data tab and then click in the Link Child Fields, Link Master Fields lines, and make sure the FK in the SubForm is matched to the FK in the main form. This should keep them synchronized.

Did that help?

mmcdonal

Hi

I should have said in my previous post that in order to embed the subform in the main form I was assuming that you would (while in design view) Click on tools and click on tile vertically which allows you to view all of your other forms.

The click on Tools ensuring that the wizard was activated Hhen this has been done drag the sub form to the main form this will activate the wizard then follow the instructions.

Otherwise take previous posting advice to link the Primary and Foreign Keys in the properties of the form

Please advise if this has solved your problem

Man Friday