>If I set the control sources of each text box to the fields in the view then when i open the form it automaticly runs the
>view before i am able to load the public variable with my date range that the view needs run the filter which has to be typed into one of the textboxes in the same form. If I set autoopen table to .F. then i get errors for every text box saying the control source is invalid or somthing to that effect.
>
> Thanks Kelly
Make sure that the view is set up for "no data on load". That way, the view is present so the control sources won't bomb on their init(), yet there won't be any funky, irrelevant data in them either. After the user selects the criteria, requery the view, and you may have to refresh your controls.
Hope that helps.