I have an interesting problem that someome may be able to give me pointers on.
On a Data Entry main form I have sub form, in Dynasheet view, where the line by line data entry takes place. Once DE is complete the Users have to validate the data by clicking on a button. The code then cycles through each record, field by field, and checks the data hasn't already been entered.
The problem I have is that there seem to be a delay from when the data is entered in the sub form and when a DAO RecordSet can see it.
I have tested the "Dirty" property for the sub form and it returns to false as soon as the user moves off the record, as expected.
The problem exists for both New records added in a session and new data added to fields of existing records.
The method I am using has worked in the past, when I had a network based FE/BE and local temp storage. For performance I have gone to a network BE and local FE, which now included the temp storage, (which is recopied each time the user logs in). This has stopped FE bloat/corruption but created other problems.
Any ideas?
TIA
Alchemy
On a Data Entry main form I have sub form, in Dynasheet view, where the line by line data entry takes place. Once DE is complete the Users have to validate the data by clicking on a button. The code then cycles through each record, field by field, and checks the data hasn't already been entered.
The problem I have is that there seem to be a delay from when the data is entered in the sub form and when a DAO RecordSet can see it.
I have tested the "Dirty" property for the sub form and it returns to false as soon as the user moves off the record, as expected.
The problem exists for both New records added in a session and new data added to fields of existing records.
The method I am using has worked in the past, when I had a network based FE/BE and local temp storage. For performance I have gone to a network BE and local FE, which now included the temp storage, (which is recopied each time the user logs in). This has stopped FE bloat/corruption but created other problems.
Any ideas?
TIA
Alchemy
