[Help] Cant add new record to subform

[Elfman]

OK here’s the deal :

Three forms:

Form A from Tbl A
Form B from Tbl B
Form C form Tbl C

Form C is embedded in Form B.
Form B is in turn Embedded in Form A.

Relationships:

Tbl A has a one to many link to Tbl B
Tbl B has a one to many link to Tbl C.

Ok so my form is set up with all forms embedded and works ok until i want to add a new set of records for Form B.

Any Idea what could be happening. Also on some computers i run it on it tells me access is generating an error log but i can't find it?

All Help Appreciated

-Elfman

 

[KeithG]

is the form setup to allow additions?

 

[Rabbie]

What error message do you get when it fails

 

[Elfman]

Em I'm not sure its actually allowing me to enter one record but not multiple records. Also it won’t display more than one record even if I manually put them in the database

 

[Elfman]

On one machine it tells me its generating a error log. on my own it said it's found an unhanded win 32 exception has occurred in access

 

[pstephens]

Try setting your subform property "allow additions" to "yes" or "true"

Hope this helps

Paul S

 

[Elfman]

OK It will allow me to enter a new record if I go to the last record and go over 1 but not with the new record command and it will store the new record but when I open the form again it will only display one record .

...Confused , I am

 

[pstephens]

Have a play with the relationship between the two tables. Backup first!

Paul S

 

[Rabbie]

It would be useful if you could post your DB so we can see what is going on. Strip out any confidential data. Compact and repair it then Zip it.