# Fill a epiComboBox from base form Combobox

**Category:** [Epicor ERP 10](https://www.epiusers.help/c/e10/5)
**Created:** 2016-10-29 14:34 UTC
**Views:** 6124
**Replies:** 9
**URL:** https://www.epiusers.help/t/fill-a-epicombobox-from-base-form-combobox/36009

---

## Post #1 by @Alex

Hi guys i use this code to fill the an epiUltraCombobox filtered with the values of a base form Combobox but the information is not coming up could you please advise? thanks in advance

private static void SearchOnWarehseAdapterFillDropDown()
	{
		// Wizard Generated Search Method
		// You will need to call this method from another method in custom code
		// For example, [Form]_Load or [Button]_Click

		bool recSelected;
		EpiCombo Combo = ((EpiCombo)csm.GetNativeControlReference("2d6cc2de-1547-4f18-907e-e00b44258d55"));
		//EpiMessageBox.Show(Convert.ToString(Combo.Value));
		string whereClause = "Warehse.Plant = '" + Combo.Value.ToString() + "'";
		System.Data.DataSet dsWarehseAdapter = Ice.UI.FormFunctions.SearchFunctions.listLookup(Script.oTrans, "WarehseAdapter", out recSelected, false, whereClause);
		if (recSelected)
		{
			// Set EpiUltraCombo Properties
			Script.epiUltraComboC1.ValueMember = "WarehouseCode";
			Script.epiUltraComboC1.DataSource = dsWarehseAdapter;
			Script.epiUltraComboC1.DisplayMember = "Description";
			string[] fields = new string[] {"Description"};
			Script.epiUltraComboC1.SetColumnFilter(fields);
		}
	}

	private static void epiUltraComboC1_ValueChanged(object sender, System.EventArgs args)
	{
		// ** Place Event Handling Code Here **
		SearchOnWarehseAdapterFillDropDown();
	}

---

## Post #2 by @Chris_Conn

I'm a beginner myself but I don't see where you are actually loading any
values into your combo

---

## Post #3 by @TGCTSE

Instead of using an ultra combo and writing all that code, use an EpiRetriverCombo and select Wharehse and let the system do it for you.

<img src="/uploads/default/original/1X/9f1643b322340049060cfd2eeef394d977dc355a.PNG" width="635" height="423">

---

## Post #4 by @Alex

so i use an epiretreivercombo. does that combobox will retrive all the info filtered by the value of the other combobox?

---

## Post #5 by @Alex

Chrise when i use these lines i amd loading the values

                Script.epiUltraComboC1.ValueMember = "WarehouseCode";
		Script.epiUltraComboC1.DataSource = dsWarehseAdapter;
		Script.epiUltraComboC1.DisplayMember = "Description";
		string[] fields = new string[] {"Description"};
		Script.epiUltraComboC1.SetColumnFilter(fields);

---

## Post #6 by @TGCTSE

the retriever combo will return all the values in the WareHse table exactly the same way as the one in the base screen.

---

## Post #7 by @Alex

the retreiver shows every warehouse i just want to show the warehouses when warehse.plant = Combobox.value in this case i call that object with the guidid

---

## Post #8 by @josecgomez

If you want to filter by Plant you can do it a couple of ways, but the easiest way to do it without writing any code is use an BAQCombo
The BAQ Combo runs a BAQ to pupulate the dropdown and you can use BAQ Markup Language to tell it what to filter by
<img src="/uploads/default/original/1X/14931527f662e79b3be93c44b307b9fa7d1cd7ec.png" width="487" height="500">

Simply write a BAQ that returns the WareHouseCode and Description then in the Filter in the BAQ Set the filter to 
Plant = [EpiBinding:OrderRel.Plant] (or whatever dataview / value you are filtering for)
<img src="/uploads/default/original/1X/333593f9999af2072f3bce6525171c7c986b66c0.png" width="504" height="500">

This tells the BAQ when bound to an BAQComobo or BAQVIew to filter by the view values at OrderRel.Plant found on the given data view.

If you don't need to filter then you can use the retriever.

Find the BAQ attached that does this
<a class="attachment" href="/uploads/default/original/1X/96f0a7d1687d1f719646dd50ebf8231e49d9e8f8.baq">WareHouseFilterByPlant.baq</a> (10.8 KB)

---

## Post #9 by @Alex

I am getting this error

Message: Key not found: 'Description'
Parameter name: key
Program: Infragistics4.Shared.v12.2.dll
Method: GetItem

this is how i set the BAQCombobox is there anything i am doing wrong? please advise

<img src="/uploads/default/original/1X/522fb9336b0ebdd086bdc91a9ec7b750bd516114.png" width="660" height="499">

---

## Post #10 by @Alex

never mid i got it thanks for the help really apreciated

---


**Canonical:** https://www.epiusers.help/t/fill-a-epicombobox-from-base-form-combobox/36009
**Original content:** https://www.epiusers.help/t/fill-a-epicombobox-from-base-form-combobox/36009