Combo Box

Olutimi

New member
Local time
Today, 06:33
Joined
Nov 22, 2020
Messages
5
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.
 
You need to bind it to a control
 
I think MajP meant bind it to a field (in your record source of the subform).
Cheers,
Vlad
 
You can also bind the RowSource to a table or query rather than using code to load it each time.
 
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;
Code:
Me.Text1 = Me.cmbSample.Column (0)

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

Me.text3 = Me.cmbSample.Column (2)
 
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
 

Users who are viewing this thread

Back
Top Bottom