Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to create a "auto-fill" style combobox AND allows to add value not found

Combo Box

How to create a "auto-fill" style combobox AND allows to add value not found

by  Mike Gagnon  Posted    (Edited  )
Create a combobox class and add the following:

[red]
In the InterActive Event of the ComboBox:
[/red]
Code: 
LOCAL lnStyle, lnLastKey, lcDisplayValue
lnLastKey=lastkey()
lnStyle = this.style
IF this.style = 2
    this.style = 0
ENDI
IF (lnLastKey>=32 and lnLastKey<=126)
    IF this.selstart>=1
        lcDisplayValue=substr(this.displayvalue,1,this.selstart-1)+(chr(lnLastKey))
    ELSE
        lcDisplayValue=(chr(lnLastKey))+allt(this.displayvalue)
    ENDI
    IF empty(lcDisplayValue)
        lcDisplayValue=allt(chr(lnLastKey))
    ENDI
    FOR i = 1 to this.listcount
            If Upper(lcDisplayValue) == Upper(Substr(This.List(i),1,Len(lcDisplayValue)))
                This.DisplayValue=This.List(i)
                This.SelStart=Len(lcDisplayValue)
                nlLength=Len(Allt(This.DisplayValue))-Len(lcDisplayValue)
                This.SelLength=Iif(nlLength <0,0,nlLength)
                this.lastdisplayvalue = this.displayvalue
                this.lastselstart = this.selstart
                this.lastsellength = this.sellength
                RETURN
            ENDI
    ENDFOR
ENDIf
[code]
[red]
In the combobox requery:
[/red]
[code]
this.Value = this.DisplayValue && Just to reset the display value
[red]
In the valid of the combobox:
[/red]
Code: 
If !Empty(This.DisplayValue)
	Local cTableName,cFieldName,nAnswer,cValue
	Store Juststem(This.RowSource) To cTableName &&Won't work for VFP5.0
	Store Justext(This.RowSource) To cFieldName && This is normally used for 3 character extension, but it works for any lenght. Won't work for VFP5.0
	Select (cTableName)
	Locate For &cFieldName = This.DisplayValue
	If !Found()
		nAnswer = Messagebox("This value was not found in the table,"+Chr(13)+"Do you want to save it in the table?",36,"")
		If nAnswer = 6
			Insert Into &cTableName (&cFieldName) Values (This.DisplayValue)
			If CursorGetProp("Buffering") > 1  && Check to see if we should use tableupdate
				Tableupdate(1,.T.,cTableName)
			ENDIF
		this.Requery() && To reset the display value
		Else
			Store ' To This.DisplayValue
		Endif
	Endif
ENDIF

Note: Properties to be created in the comboxbox class.

1. acstyle (Default value = 2)
2. lastdisplayvalue (Default value = [none])
3. lastsellength (Default value = 0)
4. lastselstart (Default value = 0)

**********************
Mike Gagnon
Note : this code was also modified to accomodate spaces in a name.
Thanks to viettla
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top