OK, I've removed the container and just placed a grid on the pageframe page and converted textbox to editbox, sparse = .f. and added the code to initialize it. Oh, and now I only have 1 column.
Now everytime I instantiate the form, I get the error:
Error with edit1 - value:Data type mismatch.
edit1 is the edit box in the grid.
However, if I ignore the error the page displays fine.
If I remove the grid and put a simple edit box on the page, and add the following code when I retrieve a record:
SELECT cnotes
WITH this.romaintpageframe1.page5.mheditbox1
SELECT CNotes.note as ro_note ;
FROM cNotes ;
WITH (buffering = .t.) ;
INTO CURSOR cGridNotes
.controlsource = 'cGridNotes.ro_note'
ENDWITH
It works fine.
One thing I did notice. When the form is initialized with just the editbox, when I step through the code, I noticed the controlsource = "" as it should be (since I don't assign the controlsource until later -- see above). However, when I put the editbox in the grid, then the controlsource keeps on defaulting to 'clookup.lup_id' which is an Integer field in a lookup table. This lookuptable is instantiated before init of the form. But nowhere do I assign that as the controlsource. Is that why I get an error, because it's an integer? How do I keep this from happening?
I'm stumped.