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

[wpearsall]

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!