Autonumber Field Causes Form To Close

[Toby Young]

I have a MS Access DB on my computer which allows other
users to access database over a network. I do not
experience this problem on my computer, but on other's
computers, when they go to add a new record to a form,
access quits unexpectedly and prompts the user to back-up
the database. They do not get the same problem if the
data is added directly to the underlying table or if they
use datashhet view to enter the new record.

I removed the autonumber field from the form and now the
database does not crash. I have 2 subforms on this form
that use the autonumber field to link between the tables.

The problem is on the form only. Is there something I can
do to fix this problem? I have already switched to a
frontend/backend set-up over the network to try to
prevent corruption per a suggestion from the newsgroup.

Any help would be greatly appreciated.

 

[Jacinto]

Try to make sure that the Master and Child Link Fields, in
the properties of the the subform are correctly done. Also
make sure you have created the one-to-many relationship in
the between the underlining tables are.

Hope that helps!