Results 1 to 3 of 3

Thread: Hellppp!!

  1. #1
    Join Date
    Oct 2003
    Posts
    4

    Angry Unanswered: Hellppp!!

    I know this question may be extremely silly, but I am stuck. I think most of problem is that i have been looking at it for so long I can't see what is wrong.

    I want to be able to (from a select case) take a value ie. Monday and pass it to a a rowsource for a list box...hehe is the select statement.

    Me.ListVolAvail.RowSource = "SELECT" & " " & "*" & " " & "FROM" & " " & "ViewVolunteerAvailability" & " " & "WHERE" & " " & "(((ViewVolunteerAvailability.Day)=" & calcday & "));"

    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.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Try something like:

    Me.ListVolAvail.RowSource = "SELECT * FROM ViewVolunteerAvailability WHERE (((ViewVolunteerAvailability.Day)='" & calcday & "'));"

  3. #3
    Join Date
    Oct 2003
    Posts
    4
    Thank you so much. I knew it had to do with the &'s and "'s but got furstrated and put them in everywhere... thank you again !!

    Whiterose

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •