Changing Records in a subform

[Ian Graham]

Hi again

I have a main form that has a subform which is a list of items from an
assets table. When a user clicks on an asset within the list I want the
details to be shown for that record in another subform. What code do I need
to put in the onclick event of the asset control?

Thanks, Ian

 

[Marshall Barton]

I have a main form that has a subform which is a list of items from an
assets table. When a user clicks on an asset within the list I want the
details to be shown for that record in another subform. What code do I need
to put in the onclick event of the asset control?

Add a hidden text box (named txtLink) to the main form's
header section.

Add a line of code along the lines of the below to the
continuous subform's Current event:
Parent.txtLink = Me.[name of primary key field]

Then set the single view subform control's Link Master
Fields property to txtLink and the Link Child property to
[name of primary key field]