>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
Mark McCasland
Midlothian, TX USA