Combobox Dropdown Problem

[ssashraf]

Hi, I have 2 issues on my form

1. When ever the combobox got focus it dropdowns automatically although I've given "me.combo1.bropdown" in KeyPress event.
2. How can I set the focus on the same textbox untill & unless the condition is satisfied (I am trying to check the Quantity in "afterupdate" event for a textbox)

Please help me.

SSA

[June7]

1. I use Dropdown method in the GotFocus event for combobox. Why do you have it in KeyPress?

2. Are you using ValidationRule property?

[ssashraf]

Thanks for the reply,
1. I am using dropdown in Keypress because whenever I press the alpha or numeric key it should drop down, If I use GotFocus then it will Dropdown which I don't want because it consist of number of items. If there is a way to get it done in GotFocus and if I press "A" then it will DropDown and gives the values for "A" that will be great for me please advise.
2. I tried using "<[Forms]![Sales Invoice]![TxtStock]" in validation rules but not working.

[June7]

1. Still don't understand. The AutoExpand property will cause the combobox row pointer to show first row that matches the input as you type in the combobox. Have the combobox RowSource query sort alphabetically.

2. don't know your db so no idea why that isn't working nor if it should