Desmond Lloyd wrote on 2014-09-05:
> Thank you, however no joy... What am I doing wrong? (you're supposed
to
> focus your attention to the west and figure it out! 8-)) I have another
> form that I am doing the same thing with and it works fine, and I don't
> even blank the record source. Create the cursor, bob.recordsource =
> 'mycursor' bob.grc1.column1.controlsource = 'mycursor.field1' and off we
> go... The code is the same in the new...
>
> Interesting enough the first three columns are just fine... Am going to
> reduce the grid to those first three columns and start building it up one
> column at a time... But if anyone has any ideas I would be most
> interested...
>
> Regards,
> Desmond
>
>
Desmond,
If you do not set a recordsource at design time, and a table/cursor is open
and active, the grid will take on the structure of that table/cursor.
To test this, you may add the following at the end of the FORM.LOAD event
SELECT 0
This will unselect any active table/cursor before the form controls
initialize.
The better solution is to have the cursor (even if it is empty) in the
FORM.LOAD event, and the GRID.RECORDSOURCE set to the cursor name at design
time.
HTH,
Tracy
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
