I'm using the DAO with a small Access 2000 database. The data for a selected field is displayed in a text box. I need the text box to display data from another table in the same database when selected (by an option button). At run time, the code under the option button: Data1.RecordSource = "table2" runs ok, but the code: txtLine1.DataField = "field2" causes the error: Unable to bind to to field or data member.

How is this done? - Bob