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 pictureId magasineName date descr
4 3 1 England 2006-10-0 nr one
5 3 2 England 2006-10-05 nr two
6 3 3 England 2006-10-05 nr three

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 pictureId magasineName date descr
5 3 2 England 2006-10-05 nr two
6 3 3 England 2006-10-05 nr three
5 3 4 England 2006-10-0 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.
Thanks in advance
/Michelle

mailto:[email protected]

 

[Klatuu]

If you are using a bound form, no save procedure is necessary. Once you
create a new record and then navigate away from the record, it is added to
the table. You must be using an unbound form, because non of the methods you
describe will do that. They all assume you are working with a bound form.

If this doesn't answer your question, post back with more detail about your
form and its record source.

 

[michelle]

Hi
Thanks for answering. me
Still, how do I know weather ther th form is bound or not?

Best regards
/Michelle

Klatuu skrev:

 

[Klatuu]

Two places to look.
Look in the Form's properties, Data tab, and see if there is anything in the
Record Source property. If there is, the form is bound.

If the form is bound, you can also look in the Control Source property of
the form's controls and it will tell you which field in the record source the
control is bound to.

 

[michelle]

Hmmm, wonder.
1)
Do you mean that I am supposed th open a form, then check properties,
tha Data tab.
There it says nothing more than 'Activated yes'. You mentioned Record
Source property un the data tab, that isn't anything I could find.

2)Then you mentioned the Record Source property which I don't know
where to find. The fact is that I have a swedish Access, so if you tell
me how to find the stuff you're talking about it would help me alot.

Regards
/Michelle


Klatuu skrev:

1)

 

[michelle]

Hi there
I'vw done as you explaned and the Record Source. shows the tablename 'm
working with, which in my opinion looks right looks right.
Any other things toc heck?

/Michelle

Klatuu skrev:

 

[Klatuu]

Do pretty much the same procedure for each control on your form, except look
in the property called Control Source. That will tell you which field in
your table it is bound to.