Combo Boxes

[djclntn]

No, I'm NOT going to bug anyone today about cascading Combo Boxes; for some reason I failed & surrender (for now). I want to ask how difficult is to have a Combo Box automatically open when I click into a next or new Record. If it's a lot of VBA Coding then just tell me & I won't go any further. Thanks in advance! dj

[ssanfu]

Hi Dave,
I use the got focus event to have the dropdown list appear:

Private Sub Combo7_GotFocus()
   Me.Combo7.Dropdown
End Sub

[Missinglinq]

For this to occur whenever you go to a given Record

Private Sub Form_Current()
 Me.ComboboxName.SetFocus
 Me.ComboboxName.Dropdown
End Sub

Replace ComboboxName, in the code, with the actual name of your Combobox.

Linq ;0)>

[djclntn]

Big Thanks to Steve & Ling. I'm playing around with both codes -- trying different things