I have the following items in the database
Tables
1. tbl_VendorList (ID=PrimaryKey, Vendors(Names)
2. tbl_VendorInvoice (Vendor field = [ID from Table 1] you can see the names but they're all connected to VendorList tbl, also contais other information)
Queries
1. frm_Search
Forms
1. frm_VendorInvoiceInput (Here I have a combobox with the list from tbl_VendorList.
2. frm_Search
So on to my question, In the search form where I have multiple text box that I can fill information that I need and have a query list. But I am having problem with the vendor list field name since they are number data type in tbl_VendorInvoice.
In the query it added
Lets say I have the following company's in the vendor field
1. Goolge
2. Amazon
...
11. Walmart
Then I have a combobox in the search form and have data sourse connected to tbl_VendorList and if I search for Google, it shows me
Google & Walmart. Since they all have 1 in them.
Tables
1. tbl_VendorList (ID=PrimaryKey, Vendors(Names)
2. tbl_VendorInvoice (Vendor field = [ID from Table 1] you can see the names but they're all connected to VendorList tbl, also contais other information)
Queries
1. frm_Search
Forms
1. frm_VendorInvoiceInput (Here I have a combobox with the list from tbl_VendorList.
2. frm_Search
So on to my question, In the search form where I have multiple text box that I can fill information that I need and have a query list. But I am having problem with the vendor list field name since they are number data type in tbl_VendorInvoice.
In the query it added
Like "*" & [Forms]![frm_Search]![src_Vendorname] & "*"
, but the query shows like following.Lets say I have the following company's in the vendor field
1. Goolge
2. Amazon
...
11. Walmart
Then I have a combobox in the search form and have data sourse connected to tbl_VendorList and if I search for Google, it shows me
Google & Walmart. Since they all have 1 in them.