AutoNumber - Replication ID Returning ? in Code

[gavinjb]

I am trying to reference the AutoNumber Field that I have in one of my tables in Code, but all it returns is a ?, but if I try access the field in a Query I get the right result from the Field.

Does anyone know haw to handle an Autonumber - Replication ID Field in Code and return the correct result, I have tried things like cstr([FieldName]), etc but have had no luck.

Thanks,

Gavin,

 

[PizMac]

what code are you using ? - an autonumber is no different to any other field - is it an empty record?

 

[gavinjb]

I have just found a solution, for using Replication Id in Auto Number fields. I have used the GUIDToString function to convert the field into something that the code window can handle.