You plugged it into the form's code? Or into the command window?
All of the lines below are the SELECT statement. Did you paste this entire section into your command window? After pasting into command window, you hit enter at the end of the command. Also, make sure you database is open. I don't see any sort of syntax error in the statement...
>Almost there, I plugged it in and It gave me "Unrecognized command verb", any changes to syntax you can recommend?
>
>
select * from finalInventory ;
where left(in_stock,2)<>"LP" ;
and iutotal<>0 ;
order by in_stock ;
into cursor finalInventoryCursor
Steve Gibson