>Good Night,
>I am writing application which assigns supervisors to staff members within their department.
>
>I created a form which display personal data for the supervisor and a command button which when click will open another form with a grid displaying all staff members of that department and supervisor assigned.
>
>From this grid you can re-assigned supervisors.
>I entered the Query (which output to a cursor) in the form's INIT event and entered the cursor name as the grid control source but this doesnot work.
>
>Is there any one who can guide me through process.
>
>Thanks in advance
>
>P.Ghervis
Peter,
lparameters tuCode
with this.Grid1
.RecordsourceType = 4
.RecordSource = 'select * from myTable where myCode = '+trans(tuCode)+;
' into cursor crsGrid'
endwith
Cetin