Just as a warning, I might have difficulty explaining this situation. I picked up a client's database after it was already completed, when it just needed to be updated to reflect changing circumstances. Access is also not my best db/programming environment.
The main form, which is an employee information type form, has two subforms. When the main form goes into edit mode, it creates a copy of the main form, pointed only to the current record. When the main form comes back from edit mode, it creates a copy of one of the sub-forms and cycles through each record in it. My changes merely added extra checks to each record check in the subform. When these are done, it updates a control on the main form and closes both created forms.
When you go back into edit mode again, the second subform, which previously showed data, only shows #Name in each control. Additionally, the user begins to get a never-ending series of "Object or variable not set," usually timed at regular intervals, which appears to me to have something to do with Access refreshing data.
I'm kind of stuck. My changes are necessary, but they do not (as far as I can see) affect anything structurally. Basically, it performs checks of a similar nature to the ones already there.
I'd really, really appreciate any help. I hope I haven't confused anyone with this.
The main form, which is an employee information type form, has two subforms. When the main form goes into edit mode, it creates a copy of the main form, pointed only to the current record. When the main form comes back from edit mode, it creates a copy of one of the sub-forms and cycles through each record in it. My changes merely added extra checks to each record check in the subform. When these are done, it updates a control on the main form and closes both created forms.
When you go back into edit mode again, the second subform, which previously showed data, only shows #Name in each control. Additionally, the user begins to get a never-ending series of "Object or variable not set," usually timed at regular intervals, which appears to me to have something to do with Access refreshing data.
I'm kind of stuck. My changes are necessary, but they do not (as far as I can see) affect anything structurally. Basically, it performs checks of a similar nature to the ones already there.
I'd really, really appreciate any help. I hope I haven't confused anyone with this.