when you create the view you set a parameter e.g ...filed=?parameter you should do some thing like : parameter="myvaleu" requery() note that the NoDataOnLoad will prevent you from getting the dialog when the form starts Arnon > >>do you use a SELECT or a VIEW (CREATE SQL VIEW AS SELECT) >>REQUERY will only work on views > >At first, I was attempting to use a VIEW and then assign it to a GRID so I >could >update any tables associated with the VIEW. I figured out how to use a >PARAMETER in the view, but not interactivly with a DROPDOWN. I could only >get the data entry dialog box VFP brings up if there is a parameter there. > >>as for making it parameterized use the syntax Gene offered >>you would probably want to specift NoDataOnLoad=.t. for the VIEW in the >>Dataenvironment as well > >I'll try this in the VIEW, but still don't know how to tie the view/grid in >with the DROP DOWN. > >Thanks > >