>I appreciate your help on my question yesterday, however, due to my own ignorance, I still need some help with your response.
>
>On the load method of my form I put in the following code:
>
> Studschd.Cursor.NoDataOnLoad=.T.
>
> where I substituted the name of my view - Studschd for the DE
>
>On the page with the grid in the Activate event, I typed in:
>
> cSoc_no = PADR(THISFORM.PageFrame1.page1.Ssn.VALUE,11)
> ?cSoc_no=Requery("studschd")
> where cSoc_no is my parameter for the view, and Ssn is the
> ssn from page 1 of the pageframe, and studschd is the nameof the view
>
>When I run the form I am still getting the box asking for the cSoc_no.
>After I enter the soc no, I get a box with error 1923 on Studschd.Cursor.NoDataOnLoad=.T., saying Studschd is not found.
>
>Please tell me what I am doing wrong with this.
>Thank!
Ok, let's go step by step. Firstly, the view, you use, is supposed to be a part of form.dataenvironment. If it's really so, then you should change (retype) NoDataOnLoad in property sheet for the DataEnvironment.Cursor object associated with the view. In Page.Activate event you may have something like:
cSoc_no = PADR(...)
=Requery("studschd")
and "studschd" supposed to be alias of your view.
Start from here and see what you will receive.
BTW, it's not necessarily to start new thread, you may continue this one.
Edward Pikman
Independent Consultant