Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

deleted records from table

Status
Not open for further replies.

reta

Technical User
Dec 23, 2004
51
AU
In the database it gives the user the option of selecting a record and all the data that relates to that peice of data will be displayed. This therefore allows them to edit the data and update the db. However, at times the user may not which to update or delete that record and return to the main menu.
The problem is that at times parts of the data that comes up in the textboxes gets completely deleted from the db is their away of not allowing this to occur.
For example:
The user selects the Part number 1234
in the textboxes the data related to that part number will be displayed:
Name: Part test
Dept: marine
Date brought: 14/2/2001
Date sold :14/2/2003
comments: test
I hope that is makes sense
Reta
 
How about in the OnClose event, prompt the user whether to commit the changes; if no, then Me.Undo.

Ken S.
 
Thats a good idea. Thanks
Reta
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top