Need Help Please, Having trouble referencing a field that is a autonumber (1 Viewer)

[gmann]

I have this module that creates a new table based on a query

Chemical_DataID is the only unique value in the query, so i genereate the table using the Chemical_DataID

If (rst.Fields![Chemical_DataID] = rstnew.Fields![Chemical_DataID]) Then

For Some Reason It doesn't Work

But If i Use
If (rst.Fields![Stations] = rstnew.Fields![Stations]) Then
Stations has duplicates so it doesn't work right, but it does
generate data

Is This Problem because in the original table Chemical_DataID is an autonumber, if so is there anyway around this problem

Thanks
Greg

 

[RichMorrison]

What is the field type of Chemical_DataID in rstnew ?
( AutoNumber is the same as a Long Integer )

How do you "generate" rstnew ?

RichM

 

[gmann]

Nermind, i solved my problem a different way

Thank You Anyway