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