I amnew in VB and I would appreciate any help
Can anyone tell me why this argument does not work?

__________________________
Dim newID
Private RS As New ADODB.Recordset

Set RS = Adodc1.Recordset
RS.Bookmark = DataGrid1.Bookmark
newID = RS.Fields("RefID")

' Adodc1, RS and Adodc2 work fine
' then here is the problem :
Adodc2.RecordSource = "SELECT Reference.*,_
Reference.RefID From Reference_
WHERE (((Reference.RefID)=newID));"
Adodc2.Refresh
_________________________________

When instead of newID I put a number everything is OK. What is the problem with newID?

Thanks in advance

emmzou