I am writing an ADP frontend to a replicated database in Access, all of the key fields have been redone to use ReplicationID rather than the standard Autonumber.
One of my forms uses text boxes to hold the relevant key value which the subforms link into. The main form is unbound, and the first subform has an oncurrent event similar to this.
me.parent("IDBox"
=[ReplicationID]
There are several other subforms that use that IDBox control to select the correct record or set of records to view.
When I try to implement this using the replication ID Access keeps freezing up on me and crashing.
When i change the text box back to displaying the autonumber then it does not crash.
The replication Id beign displayed in the text box comes on as a set of squares that cannot be displayed.
Anyone know how to help on this, I am running up against a tight deadline and dont have time to be stuck in a corner with this one.
One of my forms uses text boxes to hold the relevant key value which the subforms link into. The main form is unbound, and the first subform has an oncurrent event similar to this.
me.parent("IDBox"
=[ReplicationID]There are several other subforms that use that IDBox control to select the correct record or set of records to view.
When I try to implement this using the replication ID Access keeps freezing up on me and crashing.
When i change the text box back to displaying the autonumber then it does not crash.
The replication Id beign displayed in the text box comes on as a set of squares that cannot be displayed.
Anyone know how to help on this, I am running up against a tight deadline and dont have time to be stuck in a corner with this one.