Cannot add record with acFormAdd

[janiotjoeawie via AccessMonster.com]

Hi I have a form called frmRelations" I need to add some relations to my
database. At my Switchboard I have a item which calls DoCmd.OpenForm
"frmRelations", acNormal, , , acFormAdd
I've this same form (differnent Access databases)connected to 2 different
workspaces of the same Oracle database via linked tables. In 1 tablespace I
get the correct form without entries so I can enter a new Relation. In de
other workspace I get every time if I try it the first record of my table.
Every thing is the same becase the latter is a copy of the first 1.
Any help please.

Regards

 

[Douglas J. Steele]

Are you getting an error? Do you have a primary key defined on the table in
Oracle?

 

[janiotjoeawie via AccessMonster.com]

Hi,

I do not get an error. On the first table space it gives me my form just
ready to enter a new relation (as wanted) on the other table space it gives
me the first record of the table. The tables do have an index.

Are you getting an error? Do you have a primary key defined on the table in
Oracle?

Hi I have a form called frmRelations" I need to add some relations to my
database. At my Switchboard I have a item which calls DoCmd.OpenForm

[quoted text clipped - 8 lines]

Regards