>Hi,
>many screens in my app require looking up data. I have
>a Find button that spawns another form. On the Lookup
>form, I'd like to put in some partial data. The form should have a Textbox, a Grid, and an OK button. If I want "Roosevelt", I'd type "Roos" in the textbox and click OK. The grid would respond with all records starting with "Roos" (there may be dozens). I would scroll to the record I want and double-click on it.
>The double-clicking would leave the table's record pointer on that record and release the Lookup form.
>The Find button would then refresh the original form.
>
>1) How do I make sure the OK button is the second object
>after the textbox?
Set your tab-order so that the textbox is 1, the OK button 2
>2) How can a double-click event in a column set the record pointer and release the whole form (not just the grid).
You can write any code you want in the double-click event. Be aware that if you double-click on a column then the COLUMN double-click event is fired, not the GRID double-click. I usually set a form-variable in the calling form to the record number or unique id found in the FIND form. Then just add thisform.release and your FIND form will close.
>3) How do I build the grid so it behaves like the old
>BROWSE ... KEY in Fox 2.6?
Sorry, Don't know what you want here.
>Thanks
>John Morga
>jmorga@spec.net
You're welcome