How do you get MS access cascade combox to auto populate a textbox?

Answer by  ahsanmahmoodawan (1169)

goto the properties of the combo box find the property called "row source" click the row you will see a button on the right side with 3 titles dots on it click that button it will bring you to sql statement builder add the supplier name to the query grid close and save goto the "coloumn court"property change it 1to2

Answer by  worker63 (55)

To auto populate the text box, first you have to drag the combo box into the form from the tool box and selecting the properties of the combo box you have to set connection to the database field which suits your needy datas. The properties of the text box can be changed to hold the value of combo box

Answer by  Christian9247 (5042)

This one is easy. Auto populate the text box, first you have to go to properties and find the option, 'row source' click the row you will see a button on the right side. There will be three dot options to click. Over in the 'column Court' property change it to 1 or 2.

Answer by  gigo (1706)

You can fill the combo box over a simple sql query: Combobox1.Clear ...here comes your SQL query If RecordSet.RecordCount > 0 Then While Not RecordSet.Eof Combobox1.AddItem Recordset.Fields("Name").Value Recordset.MoveNext Wend End If

Answer by  ash23 (34)

Select distinct zipcode, city, state from..... Order by zipcode; me. txtCity = Me. cboZipCode. Column(1) Me. txtState = Me. cboZipCode. Column(2)

Answer by  Assy (29)

Go properties in combo box. row source appear bottom right side,click 3 titles dots on it.add the supplier name query grid close and save coloumn court change 1 to 2.