Hi All,
How can I have a Text Box control on a Form or Report display a record from a table? I've had trouble with this before and have had to create workarounds.
I want to be able to use the Control Source property, it seems like there shouldn't be any issue, yet I get a "#Name?" error. The workaround has been to write OnLoad/AfterUpdate form procedures to fill the box, which works, but I'd like to know once and for all why THIS doesn't work and what I should be doing.
Extra info: in the below example I am working on a Report. The table referenced contains one single record, in Short Text format. I used the 'Builder' to select the record, so no chance of typos.
Fig. 1 - Design view, showing the referenced table in properties
Fig. 2 - Report view, #Name? error
Massively appreciate any help!
How can I have a Text Box control on a Form or Report display a record from a table? I've had trouble with this before and have had to create workarounds.
I want to be able to use the Control Source property, it seems like there shouldn't be any issue, yet I get a "#Name?" error. The workaround has been to write OnLoad/AfterUpdate form procedures to fill the box, which works, but I'd like to know once and for all why THIS doesn't work and what I should be doing.
Extra info: in the below example I am working on a Report. The table referenced contains one single record, in Short Text format. I used the 'Builder' to select the record, so no chance of typos.
Fig. 1 - Design view, showing the referenced table in properties
Fig. 2 - Report view, #Name? error
Massively appreciate any help!