Combo Box (1 Viewer)

[Olutimi]

Hello All. Could someone please help. I placed a combo box on my access sub form. The combo box is populated with data on a Form Load event via a stored procedure and placed with other text boxes for data. (it is a column like other text boxes only get its data from the combo box).
When i select a value from the combo box it automatically populate the Combo box values for all the rows. Example I select a value for the combo box on row one, It automatically populate the remaining rows with the same value selected from the combo box for row one.
Please help to fix this.

 

[MajP]

You need to bind it to a control

 

[bastanu]

I think MajP meant bind it to a field (in your record source of the subform).
Cheers,
Vlad

 

[Olutimi]

Thank you all.

 

[Pat Hartman]

You can also bind the RowSource to a table or query rather than using code to load it each time.

 

[onur_can]

If I'm not mistaken, you want to transfer the fields of the query in the combo box separately into the text box, in this case;

Me.Text1 = Me.cmbSample.Column (0)

Me.Text2 = Me.cmbSample.Column (1)

Me.text3 = Me.cmbSample.Column (2)

 

[Uncle Gizmo]

If I'm not mistaken, you want to transfer the fields of the query in the combo box separately into the text box, in this case;

If onur_can is correct then you might find this video on Nifty Access useful:-

Display information from a combobox

Display Data from a Combo Box in a Text Box - Nifty Access

Display Data from a Combo Box Combo boxes are one of the most valuable controls you can have on a form, they are so versatile and give you such an extra range of functions for your form that you should really consider understanding how to use them. Also with a combobox as your foundation, you

www.niftyaccess.com