Recordset in Access 2000

[BigJimSlade]

Hi, Big Jim here:

Ok, I don't usually use Access 2000 (97 is the norm), so I am not familiar with some aspects. Here is my dilemma...

Dim rst1 As dao.Recordset
Dim str1 as String

Set rst1 = CurrentDb.OpenRecordset("SELECT ContactID FROM Calls;")
Do Until rst1.EOF
str1 = rst1![ContactID]
rst1.MoveNext
Loop

When I run this code, I get a numeric value for ContactID as opposed to the actual data.

I am using a database developed by another user where two tables are joined on this field, and so the table [Calls] has a drop down box where the ContactID can be selected. Would this be causing my problem? I can run the code on every other field in the table, and it works fine.

Thanks in advance!

Big Jim

 

[BigJimSlade]

Hi Pat,

The numeric value I am getting seems to be related to the individual's name somehow. For instance, I have 5 contracts for "Jamie", and all 5 values show up as "1", the next person's name shows up as "2" and so on.

Thanks!


Big Jim