>>>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

>
>Ummm....one more thing, I think you meant .column1.controlsource NOT .column1.recordsource :)

Yep. grid.recordsource and columnX.controlsource