G
Guest
I am endeavouring to teach myself about access by using the contact
management template provided in access and on the Microsoft Office site as
well as these forums. I am using Access 2003 and trying to copy some of the
same functionality from this template across to an access project but am
having great difficulty in filtering the embedded call notes subform (called
[Call Details Subform] in the template.
I have 2 subforms as per the template. The first [subTransactionDetails]
form contains general information such as [callID],[callDate], [user],
[transactionType], [subject] in a datasheet view and works correctly (well
seems to). The subform [subTransactionNotes] contains 1 field only called
[notes].
I want to be able to display only the notes in the [notes] field which
correspond to the which ever general information row I have selected in the
[subTransactionDetails] form.
I have followed the contacts management template and set up an expression in
a text box [txtLink] as follows;
=[subTransactionDetails].[Form]![callID]
Currently this returns the error #name
Can anyone advise where I am going wrong?
Apologies upfront if I havent provided enough information
management template provided in access and on the Microsoft Office site as
well as these forums. I am using Access 2003 and trying to copy some of the
same functionality from this template across to an access project but am
having great difficulty in filtering the embedded call notes subform (called
[Call Details Subform] in the template.
I have 2 subforms as per the template. The first [subTransactionDetails]
form contains general information such as [callID],[callDate], [user],
[transactionType], [subject] in a datasheet view and works correctly (well
seems to). The subform [subTransactionNotes] contains 1 field only called
[notes].
I want to be able to display only the notes in the [notes] field which
correspond to the which ever general information row I have selected in the
[subTransactionDetails] form.
I have followed the contacts management template and set up an expression in
a text box [txtLink] as follows;
=[subTransactionDetails].[Form]![callID]
Currently this returns the error #name
Can anyone advise where I am going wrong?
Apologies upfront if I havent provided enough information