first there is no control called a drop down. Theer is a combo box, a
list box, and a text box. If you are not using the list portion of a
combo box there is no need to even have it and thus the text box with a
button is the idea. I may be missing something but I failt o see what
difference it makes if they click an arrow button that part of an unused
combo box or click a button (that you could easily label with a down
arrow) to open the form with the list box.
Hell you could even have the list box on the same form as the text box
and just change the visible property hen the button is clicked.
You can have the second form open on the OnEnter even of the text box
but thats a real pain in the ass. you will find that it opens when you
dont want it to. Try opening the second form on double click event.
In article <11************ *********@p79g2 000cwp.googlegr oups.com>,
sy*********@syb r.com.au says...
Hi first thanks for the answer
I think the button idea is clunky and i would need to instruct people
to press the button when you automaticlly choose the dropdown. So i can
work the code to open a form with a list in it, i am struggling with
the code to pass the selected item from the list form to the combo
box..
dd
Ima Loozer wrote:
In article <11************ **********@m73g 2000cwd.googleg roups.com>,
sy*********@syb r.com.au says...
I have a drop down combo box that displays a list of customers , and
the list is growing..
I would like to click the dropdown arrow and have a List box in a new
form open, then i can choose a customer and pass it back to the combo
box.
>
can anyone help me
thanks in advance
d
>
>
Why even use a combo box in the first place then? Simply have a text
box and a button next to it. Click the button and pop up the othere
form with the data in a list box. With appropriate error trapping have
the text box on the first box set to the value of the selected item in
the list box when the second form is closed.