Using Combo Box to seek on enter or click

[amills]

I am trying to use a combo box to have users input a six digit file number to lookup a record. I have the command in the click event to seek the record and update temporary variables and that works fine. However, when I try and use the keypress event and execute the seek, it finds the wrong record or no record at all. On the screen it shows the correct number. When I put a suspend in and check the variables value, however, it is a completely different number. I want the user to be able to key in the number or click the drop down and select the appropriate record.


Andy

 

[DSummZZZ]

Are you using the combo box's Value property or DisplayValue property? You may also need to use ALLTRIM() for character values.

IF SEEK(ALLTRIM(ThisForm.Combo1.DisplyValue))
   *... Found it
ELSE
   *... Nope
ENDIF

-Dave S.-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[jimstarr]

I suspect you may be using the Value property of the combobox. Try the DisplayValue property instead.

Jim

 

[jimoo]

Also, in this instance you may try the INTERACTIVEKEY CHANGE event instead of keypress.

Jim Osieczonek
Delta Business Group, LLC

http://www.deltabg.com