SENDKEYS and NUMLOCK problem 1

[ormsk]

MS Access 97

I have an application that populates a combo box from a SQL statement AFTER the user has made some other selections. I want the combo box to auto-matically make the selection when only one items exists. I attain this by using the SENDKEYS command. The process works ok except my number lock is switched off when using some sendkeys commands. I have tried using SENDKEYS "{NUMLOCK}" to turn the numlock back on, but without success.

Anyone have any ideas?

 

[mp9]

This is a well-known bug (see

http://www.mvps.org/access/bugs/bugs0004.htm

for marginally more info).

But dont use SendKeys at all - try this instead (example assumes your combo is called cmbDropDown and is bound to something!):

If cmbDropDown.ListCount = 1 Then cmbDropDown = cmbDropDown.ItemData(0)

http://www22.brinkster.com/accessory/