Auto open of drop down list

  • Thread starter Thread starter Erik
  • Start date Start date
E

Erik

I have a database which i'm using to enter orders from
customers and keep recorders of customers address and
information. When i'm taking customer order it being done
on the phone there for it is very improtent to be fast.
How can i program the for to open the drop down menu
automaticaly and when i choose my selection it goes to
another row without me using the mouse or the tab botton.

I know its confusing but i'll try to explain.

I have a drop down menu with all the products i'm selling.
when i take the order i choose from the menu with 100
items. I want this "menu" (drop box) to open automatically
in any row. and after i finish with one row it
automaticaly goes to the next. what is the code for
that... I can't find it anywhere... Please help

Thank you in advance !!!
 
I have a database which i'm using to enter orders from
customers and keep recorders of customers address and
information. When i'm taking customer order it being done
on the phone there for it is very improtent to be fast.
How can i program the for to open the drop down menu
automaticaly and when i choose my selection it goes to
another row without me using the mouse or the tab botton.

I know its confusing but i'll try to explain.

I have a drop down menu with all the products i'm selling.
when i take the order i choose from the menu with 100
items. I want this "menu" (drop box) to open automatically
in any row. and after i finish with one row it
automaticaly goes to the next. what is the code for
that... I can't find it anywhere... Please help

Thank you in advance !!!
Click to expand...
I don't follow what you want to do when you talk about next row etc.

All I can tell you is you can have a combo box drop down using code in
some event.

If you want to it to drop down automatically for each record, then use
the Form's Current event:

Me![ComboName].SetFocus
Me![ComboName].Dropdown

Otherwise if you wish to have it drop down upon entry into the Combo
Box field, just use the
Me![ComboName].Dropdown
in the Enter event.

After that you're on your own.
 
Erik,

You have two choices; you can (a) set the combo's AutoExpand property = Yes,
or (b) add the following line of code to the combo's Enter event:
Me.cboMyCombo.DropDown

Setting AutoExpand = Yes allows you to type a value, and have Access
automatically match and complete the value for you as you type. It's a neat
feature. Adding the above line of code simply drops the combo's list portion
down whenever the control gets the focus.

You'll also need to ensure that the Tab Order is set correctly, so when
you're finished with the combo, the next control gets the focus. To set the
Tab Order, open the form in design view, right-click the form and select Tab
Order from the context menu.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Thank you very much Fred. It seems to work but now, this
drop menu is a part of subform therefor each item going to
diffrent row is it possible to write code that as soon as
i finish enter one row it will go automatically to
another. without me pressing the tab botton?

Thank you very much !!!
-----Original Message-----
I have a database which i'm using to enter orders from
customers and keep recorders of customers address and
information. When i'm taking customer order it being done
on the phone there for it is very improtent to be fast.
How can i program the for to open the drop down menu
automaticaly and when i choose my selection it goes to
another row without me using the mouse or the tab botton.

I know its confusing but i'll try to explain.

I have a drop down menu with all the products i'm selling.
when i take the order i choose from the menu with 100
items. I want this "menu" (drop box) to open automatically
in any row. and after i finish with one row it
automaticaly goes to the next. what is the code for
that... I can't find it anywhere... Please help

Thank you in advance !!!
Click to expand...
I don't follow what you want to do when you talk about next row etc.

All I can tell you is you can have a combo box drop down using code in
some event.

If you want to it to drop down automatically for each record, then use
the Form's Current event:

Me![ComboName].SetFocus
Me![ComboName].Dropdown

Otherwise if you wish to have it drop down upon entry into the Combo
Box field, just use the
Me![ComboName].Dropdown
in the Enter event.

After that you're on your own.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Graham R Seach, Thank you for your replay.

The drop down automatically works fine and now i have this
diffrent problem. This drop menu is a part of subform.
Which means that all the fileds in the form belong to one
record. I have... (ProductID)- My drop box
(UnitPrice)fixed
(Discount)fixed
(Total) which adds up

when i enter my order i use only the productID all the
other fills automatically. How can i make it so after i
finish one line of Product it will take me automatically
to the next?

I hope its not too complicated

Thank you very much for your help...
 
Erik,

Put the following code in the combo's AfterUpdate event:

If Not Me.Recordset.EOF Then Me.Recordset.MoveNext

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Great Thank you, You saved me... Everything is working fine now...

THE BEST !!! Thank you very very much
 
Back
Top