PLEASE HELP ME saving data from a from

[michelle]

Hi Folks
I'm really stuck and needs help with a saving. a new row in a table.
This is what my table Photos look like, I've added the data manually in
the table since trhe procedure 'SAVE' dosn't works. rowId is the
primarey key.


rowId boxId magasineId pictureId magasineName date
descr
4 3 A 1 England 2006-10-0 nr
one
5 3 A 2 England 2006-10-05 nr
two
6 3 A 3 England
2006-10-05 nr thre

When I save the next line from the form, this is what happens, the new
line is added at the bottom
of the table and the first line disapears.

rowId boxId magasineId pictureId magasineNam date
descr
5 3 A 2
England 2006-10-05 nr two
6 3 A 3
England 2006-10-05 nr thre
7 3 A 4
England 2006-10-06 nr four

I have tried 3 different wyas to save but none of them works, the
result is the same

1)
RunCommand acCmdSaveRecord
DoCmd.GoToRecord , , acNewRec

2)
RunCommand acCmdSaveRecord

3)
§oCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ,
acMenuVer70

What is the answer, how am I supposed to save, add the new line in the
table??
PLEASE, PLEASE help me.