drop down with down-arrow

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

Guest

I would like to make the drop down list of a combo box appear when I hit the
down arrow. Is this possible?

thanks!
 
Are you aware that you can do this simply by holding down the Alt key when
you press the down arrow key?

If you still want to do it without using the Alt key ...

Private Sub Combo4_KeyDown(KeyCode As Integer, Shift As Integer)

If KeyCode = vbKeyDown Then
Me!Combo4.Dropdown
End If

End Sub

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.
 
I have two questions - as maybe I have started off wrong with my database
project.
I have two tables for people to enter their work information into (i
imported from excel). To combine these two tables I did a union query and
based queries and reports off of. I made column changes to the tables and
realized a union query won't update so I had to rebuild - Is this correct or
is there a way around it (as people are always wanting me to go add in new
columns)? My union query currentlly reads:

"SELECT [DATE RECEIVED], [CUSTOMER], [REGION], [TYPE], [IS THIS A
CONTRACT?], [HOLD - DEAD ISSUE], [STATUS], [DATE COMPLETED/IMPLEMENTED],
[AWAITING SIGNATURE], [REQUESTOR], [DESCRIPTION], [NUMBER OF REDLINES] FROM
[BARBARA WIP] WHERE [IS THIS A CONTRACT?]=YES
UNION SELECT [DATE RECEIVED], [CUSTOMER], [REGION], [TYPE], [IS THIS A
CONTRACT?], [HOLD - DEAD ISSUE], [STATUS], [DATE COMPLETED/IMPLEMENTED],
[AWAITING SIGNATURE], [REQUESTOR], [DESCRIPTION], [NUMBER OF REDLINES] FROM
[SARA WIP] WHERE [IS THIS A CONTRACT?]=YES;

2nd Question
My question is that I want to know go into the tables and change a column to
have a drop down menu to select the city (currently they type it in). I
don't have forms - should I? Can I do a drop down or combo list in a table -
and how? Then will I need to worry about my union query and reports that I
already have built?
Please help! Thanks in advance as I have truly learned a lot from these
discussion groups.
 
Back
Top