B
Bill R via AccessMonster.com
I seem to have entered the Twilight Zone here.
I added echo off and echo on lines to the beginning and end of an existing
sub which formats a subform based on it's contents. After testing the sub,
the data in the parent form went missing! All the subform data was there
which would indicate that the parent form data was still there, but invisible.
Sure enough, when I ran the parent form's query using the suspect record's
primary key as the criteria, it returned a record with no data in the fields.
Most bizarre, the primary key (autonumber) field itself was also null! I then
queried the table underlying the parent form query using the PK, and got the
same result, invisible data. Has anyone ever come across anything like this
before? It would appear that although the data is invisible, it is still
returned based on the PK.
Bill
I added echo off and echo on lines to the beginning and end of an existing
sub which formats a subform based on it's contents. After testing the sub,
the data in the parent form went missing! All the subform data was there
which would indicate that the parent form data was still there, but invisible.
Sure enough, when I ran the parent form's query using the suspect record's
primary key as the criteria, it returned a record with no data in the fields.
Most bizarre, the primary key (autonumber) field itself was also null! I then
queried the table underlying the parent form query using the PK, and got the
same result, invisible data. Has anyone ever come across anything like this
before? It would appear that although the data is invisible, it is still
returned based on the PK.
Bill