ComboBox to stay where it is?

[hunterjj]

I have a ComboBox that has a query for the RowSource. It selects all customers that have a certain salesman code. I then pull down the list of customers and select the 1st customer that I want to place an order for and enter my order. At the end, I tab over the last field and my ComboBox goes blank. Then I have to pull it down and start looking from the beginning for the next customer. Is there a way for the ComboBox to: 1. Stay where it is. 2. Automatically drop down so I can select the next customer from the point where my last customer was in the list?

 

[PHV]

and my ComboBox goes blank
No requery of the combo somewhere in the code ?
Automatically drop down
In the GotFocus event procedure of the combo you may try something like this:
Me![name of combo].Dropdown

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hunterjj]

How would I do a requery?

 

[PHV]

I asked if somewhere in the code the combo was requeried or reassigned a value.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hunterjj]

No, it is not requeried or reassigned anywhere in the code.
I asked how would I do a requery or a reassignment?

 

[PHV]

A requery:
[name of combo].Requery
A reassignement: [name of combo] at the left of an equal sign.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hunterjj]

This helps, but it doesn't answer the question: How do I get the drop-down to stay at the last customer I processed instead of starting over at the beginning?

 

[PHV]

You have to discover why it looses its selection when you tab over the last field.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hunterjj]

That is why I wrote this thread in the 1st palce.