Cancel deleting 1st record in TBL

[txgeekgirl]

I have a Database where on 1 form the Cancel is deleting the first record in the TBL.

It's a general Cancel code

If Me.Dirty then ClearForm
LockForm

It resets the form for Editting/Adding content.

Any Ideas?

 

[Galaxiom]

Depends what your sub ClearForm is doing.
If you clear all the controls on a bound form then the current record will become empty.

Were you thinking of Undo?

 

[missinglinq]

As GalaxiomAtHome said, we really need to know the content of ClearForm, and possibly of LockForm, as well. It seems odd that you would want to 'lock the Form,' as the name suggests, if you're trying to "reset the form for Editting/Adding content."

Linq ;0)>

 

[txgeekgirl]

I guess I have looked at it so much (the back code vba) - and didn't do the forms... Thanks - I was going crazy with WHY and it was partial data deletions. 85% of the form was bound. We don't do bound forms - try to control EVERYTHING from VBA.

 

[missinglinq]

You really need to rethink your general approach! A big part of the reason to use Access for database development is the speed with which it can be created, using Bound Forms. Several developers I know, experienced in Visual Basic database development and Access development, estimate that development, using Unbound Forms, by highly experienced developers, takes twice as long as it does when using Access and Bound Forms.

There is nothing you can do with Unbound Forms that cannot be done with Bound Forms and VBA, and almost always in less time!

If you insist on using Unbound Forms, you'd be far better off using a straight VB or C++ front end with a SQL Server or Oracle back end.

• You can create an EXE file which gives total protection to your code/design
  
• You can distribute the db to PCs without a copy of Access being on board
  
• Your data security if far, far better than anything you can do in Access

So, once again, Why?

Linq ;0)>