1 To 1 Relationship Edit Problem

[Russie]

Hi.

I have tblInitialRiskAssessment linked in a 1:1 relationship with tblControlledRiskAssessment.

I've created an edit form for tblInitialRiskAssessment but because it's linked to tblControlledRiskAssessment it won't let me save.

I'm not changing any primary data, i'm only trying to edit text fields that do not affect the primary keys.

Is the edit form trying to create a new record? I have the 'Additions' attribute set to 'no' and the code for my save is below:

DoCmd.GoToRecord , , acSaveRecord

Is it the 1:1 that's preventing the edit? If so should I have a link table...I tried a table featuring a non-indexed PK to link the two but I still get the same problem.

Any ideas?

 

[RoyVidar]

Try:
[tt]docmd.runcommand accmdsaverecord[/tt]

Roy-Vidar