hmm, database problems, Editing & Adding deletes old records?

hey ya,

I just edited a record, (or two) in my DB, and it deleted ALL of my other records, i dont know how, or why,

Is it possible to open a database on two forms, and so on?


I have a couple of forms, off one database,

On it:

FrmDatabase Shows all the records (no editing etc)

If the person wants to edit a record, they load frmEditRecord,
and then it goes to the record (on a database)

Adds new record, and then they save the record,

Now... It saves the record, and DELETES THE REST.. ?

I also have a problem, that it doesnt always go to the correct record too :\ (think i totally messed something up :()

My Code is attached for it...

Now, I havent got any of its "Core" code in yet, or any real code (lol), i have spent most of my time working on the actual "GUI" for now, getting it all "looking ""Nice"" ;)"

But this is just, :@ for me and is really messing me about!

I checked your DataStorageSystem.

I see that you use DAO and that you bind the data to the Forms. The Forms look ok, but the way how you handle your data is a little .... strange (in my opinion).

Better use ADO and don't open and close always the recordset for each action. The recordscrollbar moves even to BOF and EOF, it means if you click then on Edit there will come a error.

Keep the forms, but change the life behind the forms.

nice greetings
Franky