I have a form, which contains both sub forms and sub-subforms. Everything is working correctly - except for one annoying (and potentially dangerous) thing.
When a new record is started, the data is logically entered into the main form first, and then each sub form thereafter. However, What I have found is that the data in the sub-subform is not being correctly recorded and is being "lost".
The reason for this as I have discovered is that until I have moved away from the record that has just been created, the sub-subform is not being updated with the linking data from the main form. If data is entered in the sub-subform, even though it all looks to be ok I invariably get the message "Index or Primary Key cannot contain a null value". As I have said, this is because the main field in the sub-subform is not being updated until after I have moved away from the record. As soon as I move back onto it the update has occured and data can be entered.
Is there a solution to this, so that as soon as the data has been entered in the main form, it updates the sub-subform instantly?
When a new record is started, the data is logically entered into the main form first, and then each sub form thereafter. However, What I have found is that the data in the sub-subform is not being correctly recorded and is being "lost".
The reason for this as I have discovered is that until I have moved away from the record that has just been created, the sub-subform is not being updated with the linking data from the main form. If data is entered in the sub-subform, even though it all looks to be ok I invariably get the message "Index or Primary Key cannot contain a null value". As I have said, this is because the main field in the sub-subform is not being updated until after I have moved away from the record. As soon as I move back onto it the update has occured and data can be entered.
Is there a solution to this, so that as soon as the data has been entered in the main form, it updates the sub-subform instantly?
