Odd result when linking subforms?

[Dan3412]

Hi All,

can anyone help? This might be really straightforward so sorry up front.

I'm building a DB and have got traditional sub forms on a main form with the second subform showing details of the first based on a main form. Same as the usual Access "Contact Management" Database, but with a few more layers.

But, when I create a "hidden" text box to drive the link to the second subform I get what look like chineese characters and the link doesnt work!! Although the characters change when selecting different records in the first subform.

My guess is its because Im using replication ID's, but it looked so odd I had to post See attachment.

I'd like to keep replication ID throughout since this DB is going out to remote sales reps and I want to be able to "recombine" in a central copy without having too many problems with duplicate ID's

Any thoughts?

Thanks in advance

Dan

 

[dfenton]

You might want to re-evaluate the use of ReplicationIDs in Access -- they really do cause significant problems:

Replication and GUIDs, the Good, the Bad, and the Ugly
http://trigeminal.com/usenet/usenet011.asp?1033

That said, you might be able to get around the issue by judicious use of StringFromGUID() and GUIDFromString().

 

[Dan3412]

Thanks David, maybe I'll rethink, as you suggest, didnt realise they were so difficult. Dan