However as this date only needs to be calculated once i can run it from the How do i get the public variable in the Query design page. . which I would like to load another form with a list box to select which query to use as record source for the 'View' form. . Afkorting (Initial) is the name if the textbox i made on the form.