Hi Robin,
#1 The grid should have a ALIAS this is .RECORDSOURCE
#2 what's wrong with
LOCATE FOR "CLAPWORTHY ROBIN"$CUSTOMERS.SURNAME+" "+CUSTOMERS.FIRSTNAME
?
Agnes
>Hi
>
>I've been using an inherited form class that allows me to quickly & easily pass it a few parameters and it constructs an easy to use grid, and of course I've been happily using it for years.
>
>Been asked to add a Text Search option at the bottom of the grid, no problem I thought.
>
>When I dug around inside this class, to my amazement I found the grid it creates has no alias, the control source of some of the columns can be several fields eg Customers.csurname+" "+customers.cfirstname
>
>So i've no table to search through, the grid has no alias, and the grid is not using an array.
>
>How the hell do I go through the grid, looking for my search string text, in particular I want to be able to search for say
>
>CLAPWORTHY ROBIN
>
>in the grid example, this a combination of the two fields above IE CUSTOMERS.SURNAME+" "+CUSTOMERS.FIRSTNAME
>
>Can anyone help?
>
>TIA
>
>Rob
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]