A
ajaac
Has anyone else experienced this problem? Or have a suggustions?
I've been building system for a long time and never seen this before!
Problem description:
I have an access form with a subform, the main form displays a
contract recrod and has a unique field named contractID, the subform
is a list of records associated with this contract, each record
contains a contractID field.
If I set the Link Child Field to ContractID and the Link Master Field
to ContractID, This is the normal way to link a subform to the main
form. But I'm experiencing an abort on some contract records.
First thought was a corrupt app or backend db.
I've created a new frontend app and imported all of the objects, then
compact and repaired the backend, with no change.
To verify the that it was corrupt data, I did the following.
I then created an unbound field (Test) on the main form and changed
the subform Link Master Field to use this field.
I then opened the form, moved to an offending contract record and
manually entered the contractID into the test field, and it worked!.
So the data is not corrupt.
So I added a statement to the on current event: Me!Test = me!
ContractID.
And this works OK, So now I have a workaround.
But I would really like to know what's happening behind the scenes.
I've been building system for a long time and never seen this before!
Problem description:
I have an access form with a subform, the main form displays a
contract recrod and has a unique field named contractID, the subform
is a list of records associated with this contract, each record
contains a contractID field.
If I set the Link Child Field to ContractID and the Link Master Field
to ContractID, This is the normal way to link a subform to the main
form. But I'm experiencing an abort on some contract records.
First thought was a corrupt app or backend db.
I've created a new frontend app and imported all of the objects, then
compact and repaired the backend, with no change.
To verify the that it was corrupt data, I did the following.
I then created an unbound field (Test) on the main form and changed
the subform Link Master Field to use this field.
I then opened the form, moved to an offending contract record and
manually entered the contractID into the test field, and it worked!.
So the data is not corrupt.
So I added a statement to the on current event: Me!Test = me!
ContractID.
And this works OK, So now I have a workaround.
But I would really like to know what's happening behind the scenes.