I do the following FILTER condition builder for numerous form texboxes, but here is one form textbox input for example:
pcCondition = " "
IF NOT EMPTY(THISFORM.t_address.Value)
pcCondition = pcCondition + 'mytable.addr = THISFORM.t_address.Value + AND'
ENDIF
Then later I do the following:
SELECT mytable
SET FILTER TO &pcCondition
SCAN FOR &pcCondition
...
...
...
ENDSCAN
I guess I need something more than mytable.addr = THISFORM.addr.Value.
I don't do a SELECT or a SEEK. Sorry. I found this example in Miriam Liskin's Visual FoxPro Expert Solutions, Que.
Thanks for telling me about the command button color. I wondered why there was not a BackColor for command buttons. That would be a nice property for a command button to have.
Steve Kramer
Steve Kramer
Kramer & Kramer Design
"Home of Go Cartoons"
Web Site:
www.stephenkramer.comWould you believe Far Side Lite?
More than 270 original cartoons.