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 !!!

On Tue, 23 Mar 2004 17:27:29 -0800, Erik wrote:

> 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 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.

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

"Erik" <(E-Mail Removed)> wrote in message
news:123fa01c4113f$2c34dbd0$(E-Mail Removed)...
> 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 !!!

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-----
>On Tue, 23 Mar 2004 17:27:29 -0800, Erik wrote:
>
>> 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 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.
>.
>

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...


>-----Original Message-----
>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
>
>"Erik" <(E-Mail Removed)> wrote in message
>news:123fa01c4113f$2c34dbd0$(E-Mail Removed)...
>> 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 !!!
>
>
>.
>

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

"Erik" <(E-Mail Removed)> wrote in message
news:12a2601c41148$bf587760$(E-Mail Removed)...
> 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...
>
>
> >-----Original Message-----
> >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
> >
> >"Erik" <(E-Mail Removed)> wrote in message
> >news:123fa01c4113f$2c34dbd0$(E-Mail Removed)...
> >> 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 !!!
> >
> >
> >.
> >

Great Thank you, You saved me... Everything is working fine now...

THE BEST !!! Thank you very very much