P
paulkaye
For no apparent reason, something strange is happening to my DB. When
I add a new record using a form, Access crashes and I am forced to
kill it with the task manager. Interestingly this doesn't happen when
I add a new record 'directly' into the table, nor, if after only
filling in one field in this way, I then return to the entry form and
fill in the rest of the fields.
The form has a subform within it. More specifically, the form enters
details into an 'Invoice' table and the subform enters details into an
'Items' table. The 'Invoice number' is what connects the two tables.
For some reason, even though I can't get my head around it, I can't
help wondering if this has something to do with it.
I should point out that no changes were made to the DB structure so I
don't understand why a problem like this would simply arise out of
nowhere.
Any help would be most appreciated.
Best regards,
Paul
I add a new record using a form, Access crashes and I am forced to
kill it with the task manager. Interestingly this doesn't happen when
I add a new record 'directly' into the table, nor, if after only
filling in one field in this way, I then return to the entry form and
fill in the rest of the fields.
The form has a subform within it. More specifically, the form enters
details into an 'Invoice' table and the subform enters details into an
'Items' table. The 'Invoice number' is what connects the two tables.
For some reason, even though I can't get my head around it, I can't
help wondering if this has something to do with it.
I should point out that no changes were made to the DB structure so I
don't understand why a problem like this would simply arise out of
nowhere.
Any help would be most appreciated.
Best regards,
Paul