ComboBox Search - No Results

[cvansickle]

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

[RuralGuy]

Have you tried using the UnMatched query wizard?

[cvansickle]

If I run a Query, how do I get the results into the current form..

What I have is 2 tabels

Table1 has all the data imported from excel
Table2 has a list of all current account numbers

Table1 has a field "AccountNumber" which was enter into excel and imported.

I want to search Table2 and verify that that AccounNumber is in there. If it is, I want to return a Text "Account Number Good" if it is not, I want to return a Text that says "Account Number is not Correct"

If I do a Query, will have have to find a way to make a relationship between the two?

I would like to do the search with a Combo box if possible. So I dont need any sort of relationship between the two..

[RuralGuy]

1st of all, have you tried the UnMatched query wizard to see what the results are? It asks all of the questions and no relationship is necessary. It creates a query that might give you a few ideas for your form.

[cvansickle]

Sorry RuralGuy I mis understood you.. I do now see you point. They only chanllenge I have with that is, I am not the one that will be doing the verification..

This form will be handled by the billing department. So they will do an auto import and then have other task.. Within those tasks I wanted them to be able to verify the account number..

Does that make sense.. I could have it do a query when imported to check for unmatched.. Is that pretty much my only option??

RuralGuy I truley appreciate the help!!

[RuralGuy]

There are pleanty of options depending on how much effort you wish to put into the project. My suggestion was simply pointing to one of the building blocks for what you need. It can all be completely automated and only involve the user when their input is required.