Master form and subform

[a]

thank you

I have 2 forms (master form) and sub form

I'm using link child field and link master field

And I have a command button in the master form, I want use this command
button to cut the link between master form and the sub form

I put this code in this command button:

Me.Client.LinkMasterFields = ""

Me.Client.LinkChildFields = ""

Docmd.Requery "Client"

This code let the subform not display any record I don't know the reason

Any help about How can I cut the link and display all subform data

Thank you

 

[GotQuestion]

I would also like to know how to do this.

 

[Dirk Goldgar]

thank you

I have 2 forms (master form) and sub form

I'm using link child field and link master field

And I have a command button in the master form, I want use this command
button to cut the link between master form and the sub form

I put this code in this command button:

Me.Client.LinkMasterFields = ""

Me.Client.LinkChildFields = ""

Docmd.Requery "Client"

This code let the subform not display any record I don't know the reason

Any help about How can I cut the link and display all subform data

This works fine for me:

With Me.Client
.LinkMasterFields = ""
.LinkChildFields = ""
End with

I find no need to explicitly requery. If that doesn't work for you, what is
the RecordSource of your subform, and what version of Access are you using?

 

[GotQuestion]

Thanks for your prompt response. My syntax for referencing the subform was
wrong.