Combo box

[Programming]

Hi,

My combo box selects the first value in my table , how can I prevent that?

 

[NauticalGent]

Change the RecordSource of your combo box from a table to a query and sort the query however you like.

 

[arnelgp]

dont use Bound combobox.

 

[Programming]

dont use Bound combobox.

But I want to store the selected data in a table

 

[arnelgp]

add another textbox to your form.
bound it to the field you want to save.
set its Visible Property to No.

add event (After Update) to the Unbound Combo to set the value of the hidden
textbox:

Private Sub yourCombo_AfterUpdate()
Me.hiddenTextbox = Me.yourCombo
End Sub

therefore, whatever you select on the unbound combo
will be saved to your table.