Adodc1.RecordSource = "select * from smsrecordtable"
Adodc1.Refresh
Adodc2.RecordSource = "select * from smscon"
Adodc2.Refresh
Adodc3.RecordSource = "select * from ph-number"
Adodc3.Refresh
Adodc1.Refresh
Adodc2.RecordSource = "select * from smscon"
Adodc2.Refresh
Adodc3.RecordSource = "select * from ph-number"
Adodc3.Refresh
or
Adodc3.RecordSource = "select * from [ph-number]"
Adodc3.RecordSource = "select * from [ph-number]"