Hi Roy,

Unfortunately no...

I am running a UserForm.... it woudl not make sense to do that for every enquiry. There should be an easier way. ODBC perhaps?

Just not sure of the coding.