Record selection in Datasheet, Office 2003

[Dazza]

HI Guys, dont we just love short dead lines and last minute changes.

I have a QA CA database that has a master table with linked sub tables
for costs, corrective actions etc

I have a master form with a sub form that has on each row a summary of
each QA issue.

I then have a tabbed control with subforms in for each of the linked
tables, these are in single form view

what i need to do is when a row on the top datasheet subform is
clicked on or selected, i need all the sub forms in the tabbed contol
to reference that issue.

I am pretty sure i am missing something simple on how to reference a
field on the specific row, but it has gone.

Any one got any ideas of point me in the right direction

cheers
darren

 

[Dazza]

I have a QA CA database that has a master table with linked sub tables
for costs, corrective actions etc

I have a master form with a sub form that has on each row a summary of
each QA issue.

I then have a tabbed control with subforms in for each of the linked
tables, these are in single form view

what i need to do is when a row on the top datasheet subform is
clicked on or selected, i need all the sub forms in the tabbed contol
to reference that issue.

I am pretty sure i am missing something simple on how to reference a
field on the specific row, but it has gone.

WHen you want one subform to be linked to another subform,
you need to go through the main form.

Add a text box (named txtLink) to the main form's header or
footer section.  Add a line of code to the datasheet
subform's Current event to set the main form text box:
        Parent.txtLink = Me.[linking field]

Then you can set the other subform control's link master
property to txtLink and the link child property to the
subform table's linking field.

--
Marsh
MVP [MS Access]- Hide quoted text -

- Show quoted text -

Many Thanks, i know it was something simple. I would not like to think
how long it would of taken me to work it out.

Cheers
Darren