PPRuNe Forums - View Single Post - MS Access query
Thread: MS Access query
View Single Post
Old 14th Feb 2003, 21:48
  #3 (permalink)  
Agent86
Guest
 
Posts: n/a
Cool

An easy one...

From design view
select the combo box you want to set this action to.

In the Properties select the Event tab and click in the
On Got Focus line.
Click on the Build button (the 3 dot button on the right of the line)
select Code builder

The VB code class module will open

Between these 2 lines

Private Sub Selectbase_GotFocus()

End Sub

add this code SendKeys "%{down}"


so you end up with


Private Sub Selectbase_GotFocus()
SendKeys "%{down}"
End Sub


Save your form

Now when you click or tab into the combo box the list will automatically display.

MAx