Originally posted by realgoldn
Response.Write "<option value=""" & Type1 & div & ID & FY & """>" & Type1 & div & ID & FY & "</option>"
That seems to be over kill. I assume that ID is the unique ID field? so set the vale as "...Value = """ & ID & """>" otherwise you will need to build very big strings to select the record set at the other end.

Might I also sugest that

"Type: " & Type1 & " Div:" & div & " ID:" & ID & ":" & FY

might be simpler to read as out put.

I can't be sure but it seems the problem might be that you over complicated things.

Give it a go and tell us what happened.