>Alex:
>
>Sorry to bother you again but I have searched for the last 2 hours trying to get this right. The problem is that I am a beginner and every book that I have doesn’t address any basics nor does searching the web return any walk throughs.
>
>Let’s start fresh with what you told me:
>
>1.I created a view and filtered it by a parameter named ( ?parssnumber ). Run the browse and it prompts me. I enter in ‘222-22-2222’ and I get the results. Everything good.
>
>2. I design a new form, open the data environment and drag the partcont view on the form, I get prompted enter ‘222-22-2222’ ,then somehow it codes this somewhere and everytime I try to run the form the records are filtered by 222-22-2222)
>
>3.Design a new form this time with wizard. Use the view and add the fields. Run the form, prompted for parssnumber, enter ‘222-22-2222’ everything works fine.
>
>4.Open the new form, add a property call initparameter. Go to the initparameter property and enter 222-22-2222.
>
>5.Go to the init() of the main form and add:
>
> parssnumber=thisform.initparameter
> use partcont
>
>6. Still prompts me, even though I hard coded the property.

In the DataEnvironment property sheet make sure to check NoDataOnLoad. So, the first time this view would be opened, it would not prompt you for a parameter and will open with 0 records.

Now, when you have your parameter ready do:
parssnumber=thisform.initparameter
select partcont
requery()

If it's not broken, fix it until it is.


My Blog