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.

Thanks Kelly