I have 2 tables with 5 similar named columns and I want to be able to perform a search that upon completion would show which table has the result.
For example, each table has columns A,B,C,D,E
The user selects from combo box and presses a query button.
If there are results, they show either in list box for table 1 or list box for table 2.
What I have done so far , was to create unbound combo boxes and union the fields from the 2 tables.
Next I placed a "and/or" combo box after each field.
That is where I am stuck. I am still learning VBA.
Any help would be appreciated.
Thanks (using Access2000)