Setting record source for grid is not enough.
You need to do it for grid columns as well.
And then refresh the form.
That is if you want to do it programatically at run time.
There is also another aproach ;
- Create cursor (in command window) and copy it on hard disc as free table
- Build grid with grid builder as usual
- Remove free table from dataenvironment of the form (and the disc)
- Create cursor in load event of the form
Rgds++
Sergio
>Thanks for the help. But I still don't know why my attempt does not work.
>
>CREATE CURSOR mygridcur (qty1 n(5), qty2 n(5), qty3 n(5), qty4 n(5), qty5 n(5), qty6 n(5), qty7 n(5), qty8 n(5))
>FOR stepz = 0 TO 9
> SELECT mygridcur
> INSERT INTO mygridcur(qty1,qty3,qty3,qty4,qty5,qty6,qty7,qty8)VALUES(0,0,0,0,0,0,0,0)
>NEXT
>thisform.grid2.RecordSource = mygridcur
>
>>Hi,
>>
>>As Craig said, you need record source for grid, so you simply
>>create temporary cursor with 10 records and matching structure
>>and there you go. This will also give you chance to validate
>>records in one common procedure i/o messing up with each column textbox
>>validations and all bunch of other problems you will face there.
>>
>>As far as combos and headers, you cannot put combo inside grid header object, but you can spread it ON TOP OF, or ABOVE (hair thin) grid headers.
>>
>>Rgds ++
>>Sergio
>>
>>
>>
>>>Hello,
>>>
>>>I am trying to setup a grid for entering data that is not tied to a table. The grid has a fixed number of columns (8 - columncount property) and rows (10 - by size of grid). It seems that I need to give it a recordsource, but I don't have one. I tried setting up a cursor with 8 columns of data and inserting 10 records into that cursor, but I get wierd results. Any ideas?
>>>
>>>Also is there any way to put a combohox in the header of a grid column?
>>>
>>>Thanks in advance for the help!
>>>
>>>Randy