Listbox values

[rmacleod]

How would I make it so that a List box defaults to the first value available in its list?

I need to be able to make a Calculation based on the value in the listbox...but by default no value is selected. So my calculation does not work until the value is selected.

 

[pbaldy]

Private Sub Form_Open(Cancel As Integer)

  Me.ListBoxName.Selected(0) = True

End Sub

 

[rmacleod]

thanks,
but when I use that and open the form it seems to lock things up. I can not do anything in the form. It wont let me select any other controls on the form.

 

[KenHigg]

Me!ListBoxName.Selected(0) = True

???

 

[pbaldy]

Curious, as it works fine on my PC (A2k). Can you post a sample db?

 

[ChrisO]

Looks like it does lock up the Form in A97 at least when using the Form_Open event.

Seems to work OK in the Form_Load event but referencing the value required specifying the Column even if there is only one column.

This works and Column is required to referencing the value.

Private Sub Form_Load()

    Me.ListBoxName.Selected(0) = True
    Me.txtMyTextBox = Me.ListBoxName.Column(0)
    
End Sub

Thereafter the column is not required to reference a single column List Box.

Private Sub ListBoxName_Click()

    Me.txtMyTextBox = Me.ListBoxName
    
End Sub

Might be just an A97 thing???

Regards,
Chris.

 

[rmacleod]

Actually it is happening for me in Access2k3.

I will try it in the load form event instead.