Hello all..
I have a small project wherein I import data from an excel file. One of the fields needs to verified against a 2nd table to ensure it was entered properly.
So what I have done is created a ComboBox search to find the record in a seperate table and make sure it was entered correctly.
What I need help with is 2 fold.
1) Right now, I have to re-enter the number into the combo box to do the search, I can cut and paste. I would like to have it just search that field. I have tried to make the field default to the other field and I also tried to create a button that Combo123 = AccoutNumber. But neither of these worked.
2) If it is incorrect, it has a message box that tells me "The Text you entered isn't an item on the list". What I would like it to, is return a small message in a seperate TextBox "Number incorrect, Please verify Number"
Any Ideas??
Thanks in advance
Chad