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