Hi,
My table's PK is a replication ID. If I display the value
in a form it is as expected, eg {ADSSD..SSD}. However if I
access the value programatically, eg MsgBox Me.PrimaryKey,
the value is always returned as "????????".
I need to get at the real ReplicationID (a GUID) because I
need to create child records in some cases and the ID is
needed as a foriegn key in the child table.
How can I get access to my record's PK value in GUID
format?
BTW this is not while I'm creating the record, ie the
record already exists and has already been given a valid
ReplicationID value.
TIA - Peter
Douglas J. Steele - 23 Dec 2003 11:48 GMT
Try MsgBox StringFromGUID(Me.PrimaryKey)

Signature
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
> Hi,
> My table's PK is a replication ID. If I display the value
[quoted text clipped - 14 lines]
>
> TIA - Peter
Peter Jones - 23 Dec 2003 21:59 GMT
Thanks Douglas - spot on!! Cheers, Peter
>-----Original Message-----
>Try MsgBox StringFromGUID(Me.PrimaryKey)
[quoted text clipped - 19 lines]
>
>.