Here is my problem:
I have a search form in the project I am currently working on, and I have no idea how to go about making it work. I want it to search and display data for a “Tag ID entered by the user. Here is the fun part. I want it to check for the record in 4 different tables (“QCHold, “Rework, “Recut, and “Scrap). Now, the record will not be in multiple tables, there is only one instance of it. For example, I want it to search through “QCHold, and if it finds it there, display the data and exit the sub. But, if it doesn’t find it, I want it to go on to another table to check. I want it to keep searching until either it finds the record in one of the tables, or until it reaches the end of the last table (if the record doesn’t exist).
Database: MS Access
Possible future problem:
If I get this to work, how would I go about deleting a record from the search? I have tried this before, but haven’t gotten it to work since I didn’t have an index for the record, because I just displayed the data. I would always get a reference error.
I would be grateful to anyone that can help or point me in the right direction, and I could send whoever helps a mix cd or something. ;)
...just a warning, if I don't understand, I'll probably have a bunch of questions since I have no formal training in VB.Net. I've been teaching myself with help files, but I couldn't find anything for this particular task.
Thanks for your time,