Thanks very much to both of you.

Much appreciated.

Cheers

Hi, sorry for late reply.

Thanks very much for you input, I will definately try you SP.

Again, thankyou.

================= UPDATE ==========================

I ran the code and it worked like a dream.

Thankyou yet again...

Hi all,

Thanks for your help, I have managed to get whet I wanted.

You gave me some ideas and that is very welcome.

Cheers

Hi all.

Thanks for the replies, and they helped me with this problem.

I managed to get the data I wanted in a roundbout way and it worked fine.

Thanks again.

Hi again,

I used the code above and I now get the following error.

ADODB.Parameter error '800a0d5d'

Application...

  sqlstring= "EXECUTE UpdateORGDetails '" & Contact_Person  & "', '" & Managing_Organisation  & "', '" & Name_of_Centre  & "', '" & House_Name_No  & "', '" & Street  & "', '" &...

Sorry not an expert at this yet.

============== CODE ===============

CREATE PROCEDURE UpdateORGDetails

@Contact_Person varchar(50),

@Managing_Organisation varchar(50),

@Name_of_Centre varchar(50),

@House_Name_No varchar(50),

@Street varchar(50),

@District varchar(50),

@Town varchar(100),

@PostCode varchar(15),

@Telephone varchar(20),

@Fax varchar(20),

@E_Mail varchar(100),

@Web_Site varchar(100),

@Centre_Type_School Bit,

@Centre_Type_Library Bit,

@Centre_Type_Youth Bit,

@Centre_Type_CollegeMain Bit,

@Centre_Type_College_Outreach Bit,

@Centre_Type_Women_s Bit,

@Centre_Type_Ethnic_Minority Bit,

@Centre_Type_Museum...

Cheers m8, that sounds exactly right, I do not have the correct permission on the network.