>One more thing, how can I use only a few fields in my grid? I've got a SQL statement that has 9 in it but I only want 4 from that cursor in my grid...is there and easy way to do that without issuing another SELECT and pulling only those 4 fields?

Put the following code where you need it:

with thisform.gridname
   .columncount = 4
   .column1.recordsource = 'mycursor.fieldname1'
   .column2.recordsource = 'mycursor.fieldname2'
   .column3.recordsource = 'mycursor.fieldname3'
   .column4.recordsource = 'mycursor.fieldname4'
endwith