Unanswered: help building a search page/sheet/field whatever I need?
What event proceedure can I use or code I can write to do a search then open a form with that record?
I want to be able to have a combobox. (Something like an InputBox in Excel)
Enter something like "CAT". Click it then;
Have it show a list of all companys from the form TblBillTo table with CAT in them.
COOL CAT KENNELS
Then I want to be able to click on the word and it will open my form called FrmRequestForWO and enter
this record of the company name I just clicked.
Am i asking for the impossible?
Any help is greatly appreciated,
If I need to give more information, let me know!!
Let me explain clearer.
Actually I have figured out on my search form how to get the "CAT" solution!!!!
2nd step I need help on is...
I have a Form called "FrmSearch"
The FrmSearch Form has let's say 4 results on the page.
I want to click the results I want. Let's call this "strSearchData" (This result is from a table "TblBillTo")
After I click one of the choices, i would like a Form called "FrmRequestForWO" to open and the strSearchData would be entered in the "BillToId" field on FrmRequestForWO. And then close the FrmSearch.