
ACC2000: DLookup() specifications
I'm not quite sure whether you are trying to return the Replication ID or use it
in the critiera statement.
You may need to use StringFromGUID or its converse GUIDFromString to get a
"Readable" value
Here is a test function I used to get a readable value on some data I have that
uses replication id.
Public Function fTestLookup()
Dim varReturn As Variant
Dim varString As Variant
varReturn = DLookup("StringfromGUID(fldAdminElementRid)", _
"tblEPSDTAdminElements", _
"fldAdminElementName= ""Back up generator"" ")
varReturn = DLookup("fldAdminElementName", _
"tblEPSDTAdminElements", _
"StringfromGUID(fldAdminElementRid) = """ & (varReturn) & """")
End Function
Quote:
> I am attempting to pass to method DLookUp() as criteria, a
> data type with field size = ReplicationID
> the character string '?????' is being returned.
> this field is currently the primary key for its host table
> and converting to another field size would be problematic.
> suggestions??