calcday is calculated correctly based on the [Startdate] on my form. My Select case is case 1 means it is sunday case 2 monday...etc.
When the select statement runs it prompts me with a parameter dialog that says Tittle Enter Parameter, Message is Monday then gives me the area to type my parameter. However, monday is suppose to be the criteria. My query itself doesn't have anything in the criteria under ViewVolunteerAvailability.Day to begin with.
PLEASE HELP I am confused and need someone to look at teh statement and see if they can see why it is doing that.