Vanishing Sub-Form Data

[ADezii]

I am experiencing an extremely peculiar problem, which occurred immediately after converting a self-contained Access 2003 database to a Front/Back End architecture. When I enter a specific field ([SubLocation]) in a Sub-Form and move the Mouse to other Records within the same field context, all values in those fields will consecutively disappear. The integrity of the underlying data is intact and a Data Refresh, Form/Sub-Form Requery, or Refreshing the Table Links does not solve the problem. The Main Form must be closed and opened again for the data to be properly displayed. This problem does not exist within the self-contained version of the database. There is no code in the MouseMove Event of this field. The Enter Event of this field contains code, which modifies the RecordSource of the [SubLocation] field based on the value of the current [Location]. I am at my wits end – can anyone provide some insight into this situation? Thanks

[NeoPa]

Did you ever get a resolution to this ADezii?

[ADezii]

Did you ever get a resolution to this ADezii?

No one from this planet has ever encountered a similar problem, and to this day I have never found the underlying cause. Had to create spaghetti code that writes to a Local Table then updates the Back End on the Server. A real nightmare for keeing the data in sync, since other Users are duplicating this process on their localized Front Ends. Thanks for the thought.

[nico5038]

Hmm, I've had some strange problems when a bound field was present on the report, but the field was removed from the report's query.
Perhaps worthwhile to check your fields.

Did you also try to decompile the splitted .mdb ?

Nic;o)

[PEB]

I am experiencing an extremely peculiar problem, which occurred immediately after converting a self-contained Access 2003 database to a Front/Back End architecture. When I enter a specific field ([SubLocation]) in a Sub-Form and move the Mouse to other Records within the same field context, all values in those fields will consecutively disappear. The integrity of the underlying data is intact and a Data Refresh, Form/Sub-Form Requery, or Refreshing the Table Links does not solve the problem. The Main Form must be closed and opened again for the data to be properly displayed. This problem does not exist within the self-contained version of the database. There is no code in the MouseMove Event of this field. The Enter Event of this field contains code, which modifies the RecordSource of the [SubLocation] field based on the value of the current [Location]. I am at my wits end – can anyone provide some insight into this situation? Thanks

Hi,

I've had the same problem! There is long time that i'ven' t had it but before i've removed all heavy code and expressions.

Pls verify that there is no null data that participate in ur recordset and u check in it for not null data!

Yesterday just i've had this pb with Access 2.0! Imagine only! :)

[PEB]

Sometimes i've other pb: in All Fields it is written #Name and can't see anything behind!


And in fact also when there is no users and i'm the only one in the front end /back end database this prb appeared!

Check ur expressions! Do them sas simplier as possible! And expect the use of null!

[ADezii]

Hmm, I've had some strange problems when a bound field was present on the report, but the field was removed from the report's query.
Perhaps worthwhile to check your fields.

Did you also try to decompile the splitted .mdb ?

Nic;o)

Tried that also, thanks.

[ADezii]

Hi,

I've had the same problem! There is long time that i'ven' t had it but before i've removed all heavy code and expressions.

Pls verify that there is no null data that participate in ur recordset and u check in it for not null data!

Yesterday just i've had this pb with Access 2.0! Imagine only! :)

Data in question are all Required, Numeric Fields derived from a multicolumn Combo Box.