This is the method run by a combo upon opening the form......

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
CLOSE DATABASES
OPEN DATABASE ('c:\diamondaccounti\inventory')

if !used('Searchmode')
use Searchmode
else
select ('Searchmode')
endif


SET ORDER TO stocknum...........
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
references to other field/object pairs follow.