Hi Barbara,
I hope that you understand what I am going to describe below. If you have experience on that, please help me again Barbara!
I tried to create a parameter form for my own to go to the reports(and forms also). Before I used the default "view parameter", and it's inconvenient because the users got confused by its design. The way I created my parameter form is:
*Create a small form which has 1 textbox(to enter the Product's name), a button(to go to the report or form)
*On this small form, I add a variable to its "Property/Method" which I call variable_Proname. Then on "VALID" method of the Text I have
thisform.variable_Proname = thisform.Text1.value
*For "Unload" method of the small form, I have
return(this.variable_Proname)
*For the button, I have "thisform.release"(click method)
*The code for the "Stored Procedures":
***************
procedure find_product
local proname(this is what I have for the filter of the "View designer")
proname = ""

do form connect_proname to proname (to connect the small form to the view)
if !empty(proname)
= requery("inventory")
endif
endproc
****************
Finally, for the form or the report(my destination), I call the "Procedute"
*****
do find_product
dodefault()
*****
Everything works beautifully for me in this way. But the problem I have now is I am not only looking for the "product name" but also the "quality" of the products. If I have more than 1(or more) variable on the small form(2 filters for the "view designer") how to deal on the Procedure?
Once again, I really need your advice here.
Thank you so much in advance.
Diane.