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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Comparing Data

Status
Not open for further replies.

ktchan741

Technical User
Dec 7, 2003
28
SG
I have created a form using vb.net.
The form has the following fields and a Datagrid:
a. Revision
b. Installation
c. Part No
d. Qty
e. Description
f. Change Rev (Field is Disable - autofill based on criteria)

The form also has the command buttons: Save and Close

For initial revision "-", I am able to capture and saved what was key-in the above fields (except "Change Rev").

For making subsequent revision, "A" (for example), the previous revision data is recaptured onto the fields.

However, I have a problem. Is it possible when there is any changes made to any of the following field (Part

No, Qty and Description) that is different from the previous revision, the field "Change Rev" will auto-fill

the current revision "A" in Change Rev. The purpose is to tell the user which set of data is change and in

what revision, if there is no change make to data, the Change Rev remain as "".

Example:

Rev Installation Part No Qty Description Change Rev
- -1001 - - ENGINE
- -1001 123-1 1 HANDLE
- -1001 765-N1 1 HOLDER
-----------------------------------------------------------------
A -1001 - - ENGINE
A -1001 123-12A 2 HANDLE CASE A
A -1001 765-M3 1 HOLDER
-----------------------------------------------------------------

Any advise how to approach the above is appreciated. Thanks
 
I would try the .textchanged event you can handle all textchanged events in one sub by doing this

private sub ... handles txtrevision.textchanged,txtinstallation.textchanged,...

and then write the code to update the change rev

Christiaan Baes
Belgium

If you want to get an answer read this FAQ faq796-2540
There's no such thing as a winnable war - Sting
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top