Linking subforms on a tabbed page

[Guest]

Hello,

I have a database that uses a main form with several tabbed pages. On one
tabbed page I have two subforms. The first subform lists all the records in
datasheet view. When the user selects a record in the first form it should
display the details for that specific record in the second subform.

I have created a hidden text field (txtRelay) that references the id field
for the selected record in the first subform
([fsubSec_Data].[Form]![txtSecurityID]) and placed it on the tabbed page. I
then have tried to link the records on the second form using the Master and
Child fields. The Master field is set to 'txtRelay' and the Child is set to
'SecurityID' which is part of the recordset for both forms.

Unfortunately, the second form doesn't show any data.

Thank you for your time.
Shaun

 

[Guest]

Please ignore. Spelling error kept me banging my head against the wall for
over an hour. Must need more caffine.

Shaun