Cheers mate, that bloody apostrophe gets me every time!

I can get the query to populate the dropdown, just not pass to the query page.

I don't think me not posting is an option at the moment, but as soon as I contribute something other than questions, I will.

Any other suggestions for a replacement to...

Thanks (again) Steve.

I'd tried that method before and got no joy, it looks like it's worked that time, thanks.

I need to add extra parameters to the SET

line, but I think I'm on...

SQLStmt = "UPDATE helpdesk SET progress = 'txtProgress' where SupportID = 'LogNo'"

should read

SQLStmt = "UPDATE helpdesk SET progress = 'txtProgress' where SupportID = 'txtSupportID'"