RecordSets

  • Thread starter Thread starter Nbene
  • Start date Start date
N

Nbene

Hi,

Hope someone can help with this one.

I am looping through a list of tables and their apprporiate Unique
Identifier name
[tblID, tblTableNames, tblUIDName]

''''' etc.

Strtable = tblTableNames
StrUID = tblUIDName

StrSQL = "SELECT " & strTable & "." & StrUID & " FROM " & strTable &
";"
Set RecSet = CurrentDb.OpenRecordset(StrSQL)
If RecSet.RecordCount <> 0 Then
Do While Not RecSet.EOF
strPrimUnique = Nz(RecSet! & StrUID, "")

My issue is the last line here...... strPrimUnique = Nz(RecSet! &
StrUID, "")
IS IT POSSIBLE to set a variable to this

My compile error says Type Declaration character does not match
declared data type...

then I tried to declare it first with RecSrc3 = "rsSrc3!" & StrUID
and then strPrimUnique = Nz(RecSrc3, "") but alas this did not work
either....

Is there anyway around this.

Please help me..... :)

N
 
Back
Top