Question:
In my program from a combo list one can select an item (that happens to be a table in an MDB file)so that the DATA1.recordsource matches the item selected and the database should change; now my problem iswhen I select an Item from the combo, the data1.recordsource changes as far as the data1.caption is concerned,the text of a textbox does not get update accordingly even if the object is bound to data1.

Answer:
Did you do a Refresh on the data control? You have to do that when you change the RecordSource property.