> Interesting - but when I leave the recordsourcetype as 4 and leave the bindcontrols set to .t. and build the cursor before the form it is not read only.
>
> Indeed - perhaps this is a bug - or at least a bug in the help file because the help file says that when the RecordSourceType is 4 the RecordSource is ReadOnly < s >.
>
> Regards,
> Marcia G. Akins
> Tightline Computers, Inc.

Marcia,
Interesting - not in my help file (though I certainly could have missed it :) )

Specifies how the data source that populates the Grid control is opened. Available at design time and read/write at run time.


Grid.RecordSourceType[ = nType]


Return Value
nType


The settings for the RecordSourceType property are:
Setting Description
0 Table. Automatically opens the table specified in the RecordSource property setting.

1 (Default) Alias. Treats the record source as specified.

2 Prompt. The user is prompted for the record source at run time. If a database is open, the user can choose one of the tables it contains as a record source.

3 Query (.qpr). The RecordSource property setting specifies a .qpr file.

4 SQL Statement. The SQL statement is specified in the RecordSource property.


In any case, give it a try and see what it does - I'm curious to see if it is read only for you.



Dan
"Our gold does not chink and glitter. It gleams in the sun and neighs in the dark." Chief Joseph