Opening a ComboBox with a default selection in Access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please, how can we affect a default index in a cboBox at the opening of a form (thru VBA code or else...)
Let say I want the 3rd entree out of 10 to show at the opening of the form..
 
Hi,
Sure, something like this:
Me.cboCust = Me.cboCust.ItemData(2)

in the Open event.
 
Louis said:
Please, how can we affect a default index in a cboBox at the opening of a form (thru VBA code or else...).
Let say I want the 3rd entree out of 10 to show at the opening of the form..
Click to expand...


Use the form's Load event:

Me.cboBox = Me.cboBox.ItemData(2)
 
Back
Top