database bind error

Using ADO, When I change the recordsource at run time, the I get a UNABLE
TO BIND TO FIELD ITEM (ERROR 545). If I run the code below, ViewTableOne
will run ok, then ViewTableTwo will error on the line shown.

Call ViewTableOne()
Call ViewTableTwo()

Private Sub ViewTableOne()
Adodc1.RecordSource = "Message_One_Table"
Text1.DataField = "Message_One_Field_1"
End Sub

Private Sub ViewTableTwo()
Adodc1.RecordSource = "Message_Two_Table"
Text1.DataField = "Message_Two_Field_1" <--- ERROR ----
End Sub

Thanks for any help - Bob

After you change the .RecordSource of the Adodc, you may need to do an Adodc.Refresh. Trying adding that and see if it helps.