Updating a VBA Form

[AlanJ]

hi, i'm using the VBA forms as a nicer interface for excel.

I have a couple of forms, one for entering data and a second for updating it should any information change.

They both work ok, except if the "TP Job number" is actually a number not a code like HB123.

if i use a number like 123 as the code then i get an error.

I assume this has something to do with how it identifies what row it will look at but can't figure out a work around

The basic's of the code i'm using for this is (though the full file is attached)Example v3.2.xls

Dim myRow As Long

myRow = Application.Match(Me.cboTPJobNumber.Value, Sheets("TP_Job_Details").Range("A:A"), 0)
Me.txtIssues.Value = Application.Index(Sheets("TP_Job_Details").Columns(4), myRow)

Any help would be most apreciated.

Thanks,

[JBeaucaire]

How about this? You only need to get the myRow once, then you can use it over and over...:

Please Login or Register  to view this content.

[AlanJ]

Thank you very much,

Not only has that fixed it, it's a tidier way to do the code.

Thanks again,
AJ

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.