Form just shuts down in Access 2002...

[Sarah Bendele]

I have recently converted a database from Access 97
(Office 97) to Access 2002, Windows XP.

I have a main form which has two subforms on it, and
subform B contains control tabs with 6 subforms on those
tabs. Both subforms take a key from the main form (a
record ID). The Main form cycles all records, as do the
subforms.

The problem is that when I try to cycle through the main
form's records (using either the record selectors or self-
created buttons), access just shuts down with no clear
error message. If I remove the subforms, there is no
problem.

Any advice is appreciated.

 

[Allen Browne]

Sarah, please tell us a bit more about the connection between the main form
and the subform.

If you open the main form in design view, right-click the edge of the
subform control and choose Properties, what is in the LinkMasterFields and
LinkChildFields properties? Are these the names of fields in a table, or
just text boxes on the form or subform, or perhaps calculated fields in a
query (if the form or subform is based on a query)? What data types/field
types are these?

Is there any code in the Current event of any of these forms?

Make a copy of the mdb file (while it is not running).
Delete one of the subforms from the main form.
Compact it to get rid of any temp objects.
Does the problem still occur?
If so, repeat for the other subform.
Are you able to determine which subform causes the problem?