Thread: Combo Boxes
View Single Post
  #2  
Old January 22nd, 2009, 07:15 PM posted to microsoft.public.access.gettingstarted
MikeJohnB
external usenet poster
 
Posts: 464
Default Combo Boxes

Try looking at the help for combo boxes provided in the VB help.

Example
The following example shows how you can use the Dropdown method within the
GotFocus event procedure to force a combo box named SupplierID to drop down
when it receives the focus.

Private Sub YourComboName_GotFocus()
Me!YourComboName.Dropdown
End Sub

Will display the contents list of the combo as it receives focus. ie you
will not have to click the button you spoke of.

I hope I have understood your first problem?????

As far as your second problem goes, I don't understand what you are trying
to do from your description. Can you please clarify? If its the list order
that appears in the drop down, you change the order in the underlying query
of the Combo box, Click the three dots in the Row Source, open the query in
design view and just drag the columns into the order you want them to appear
in the list. This would normally be done as you use the wizard tho so perhaps
I don't understand what you mean on this one????

Does this help????

Kindest regards
Mike B
--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Ray C" wrote:

I have taken to using Combo Boxes in my main form instead of using a seperate
Menu or Switchboard and I have two questions.
1. Is it possible to have the Combo Box Selection drop down when the combo
is selected as being live? I have tried all sorts bu can only have the combo
box display and the dropdowb selection become "live" when I click the small
arrow at the side. I would like it to display the options as I am offering
the selections to the user.
2. is there any way to make the combo's first item available in the list be
displayed first? What I mean here is that Combo 1 with Option 1, option 2,
option 3 etc as its selections would show option 1 in the Combo Box with
Option 1, shown again as the lead option in the drop down menu.

Any thoughts, help appreciated Thanks Ray C