I know you guys have seen this error message before; Most of the field names have a space between them. For Example: Job id, add no, telf no... etc. I don't know how to define them on this statement:
response.write("<option value=""" & rs("job id") & """>")
I've already tried to put  around "job id", also I removed the quotes around it but it doesn't work. Do you have any other ideas??
Item cannot be found in the collection corresponding to the requested name or ordinal.